Are there any apostrophe's or spaces, if so see
http://support.microsoft.com/?id=107468
Regards,
Sandy
-----Original Message-----
Yes I did. Thanks for the suggestion. I believe the
code
is correct. It's the error message that pops up when
opening the book that is causing the problem.
BEGIN ERROR MESSAGE
Errors were detected in [filename] but Microsoft Excel
was
able to open the file by making the repairs listed
below.
Save the file to make these repairs permanent.
Renamed invalid sheet name.
END ERROR MESSAGE
I'm now trying to find out how to prevent this message
from popping up (there is nothing wrong with the "sheet
name").
-----Original Message-----
Have you tried recording a macro whilst manually opening
your file, then compare new vs the old (including
reportDate).
To be sure code each into cells, and in another try
=A1=A2
Regards,
Sandy
-----Original Message-----
The following line of code worked before I was upgraded
to
Windows XP and Excel 2002.
Workbooks.Open
Filename:="C:\Inetpub\wwwroot\BCC\documents\200 4_E_M_Cal
e
n
d
ar_" & reportDate & ".xls"
The program stops at the above line with the message:
Run-time error '1004':
Method 'Open' of object 'Workbooks' failed
The rest of the program works if I manually open the
workbook and continue with the rest of the code. Any
suggestion is appreciated. Thanks.
.
.
.