Excel extension issue(s)

[cstimart]

I have many files with macros that reference other excel files and now that I have been converted to Office 2007, the extensions are changing.

Is there away to call another file w/o having the specifically reference .xls, .xlsx, or .xlsm so that it will access the file no matter the specific excel extension?

 

[Jon von der Heyden]

Unless, I am missing something, won't Len(strFileAndPath) > Len(strPath) be true 100% of the time?

No. Dir will yield an empty string if the file cannot be found / doesn't exist.

strPath = "C:\"
strFileName = "Test"

If the file is found then strFileAndPath e.g.: "C:\Test.xlsm"
Then strFileAndPath will have a longer length than strPath. This will be true and the file will open.

However, if the file doesn't exist then strFileAndPath "C:\".
Then strFileAndPath will be of equal length to strPath. This will be False and the file will not open.