G
Guest
I had a procedure that called to open a workbook:
sAddress = \\Servername\Part\Folder1\Folder2\Folder3\File.xls
Workbooks.Open sAddress, 0, False
This worked perfectly well in Excel 2000, but after upgrading to 2003, it
kicks back an error stating Method 'Open' of object 'Workbooks' failed.
I checked and the file does exist where the address is, and can be opened
manually. I did some testing and I was able to figure out that after a
certain number of folders deep, the open function no longer worked. Is there
a maximum length allowed for the file path now?
sAddress = \\Servername\Part\Folder1\Folder2\Folder3\File.xls
Workbooks.Open sAddress, 0, False
This worked perfectly well in Excel 2000, but after upgrading to 2003, it
kicks back an error stating Method 'Open' of object 'Workbooks' failed.
I checked and the file does exist where the address is, and can be opened
manually. I did some testing and I was able to figure out that after a
certain number of folders deep, the open function no longer worked. Is there
a maximum length allowed for the file path now?