I have a folder. In that folder there will be only one file.?

Concerning a folder.In in which folder you will have only one particular excel record.That excel in life file name keep changing all the time.When MY PARTNER AND I run your macro it should head over to the folder in addition to open this single stand out workbook current inside which folder.Considering that name in the workbook continues changing, i cant identify the name with the workbook with macro value.Could everyone please guide me with the code

Hi,

It will do it for you:

Subscription Open_My_Files()
Poor MyFile Because String
‘change mypath for the directory where the excel file exists
MyPath = “c:\”
MyFile = Dir(MyPath)
In the event that MyFile Such as “*.xls” Then
Workbooks.Available MyPath & MyFile
Ending If
Ending Sub

Thanks:).