AdrianK
07-18-2011, 09:26 AM
Hello All,
Not sure it anyone has come accross this problem before?
I am trying to use the following code:
strFOLDER2 is the string folder name
strMONTH is the string format number of the month (e.g. 07)
' Open existing file
Workbooks.Open Filename:="\\SERVER\Folder1\ (file://server/Folder1/)" & strFOLDER2 & _
"\FILENAME - " & strMONTH
The variables contain the correct values and the whole filepath is correct.
The code was written in 2003, but we are currently 'upgrading' to 2010. Works fine in 2003, but in 2010 comes back with a 'Microsoft Excel cannot open the file...' error.
The file is a 2003 file, and this can be manually opened from 2010 without issue, but the macro will not open the file.
I'm hoping i'm missing something really really simple, but have tried all I can think of to sort this. (including using the mapped drive letter rather than the server name).
Can anyone please help?
Cheers,
Adrian
Not sure it anyone has come accross this problem before?
I am trying to use the following code:
strFOLDER2 is the string folder name
strMONTH is the string format number of the month (e.g. 07)
' Open existing file
Workbooks.Open Filename:="\\SERVER\Folder1\ (file://server/Folder1/)" & strFOLDER2 & _
"\FILENAME - " & strMONTH
The variables contain the correct values and the whole filepath is correct.
The code was written in 2003, but we are currently 'upgrading' to 2010. Works fine in 2003, but in 2010 comes back with a 'Microsoft Excel cannot open the file...' error.
The file is a 2003 file, and this can be manually opened from 2010 without issue, but the macro will not open the file.
I'm hoping i'm missing something really really simple, but have tried all I can think of to sort this. (including using the mapped drive letter rather than the server name).
Can anyone please help?
Cheers,
Adrian