Okay. I created the path and file name noted below and it
DOES open in my program. Hmmm... I know everything is
correct as far as the path and file name with my original,
however, when I attempt to open the file with Windows
Explorer I get a "Renamed invalid sheet name" error
message.

-----Original Message-----
I just tested this
Workbooks.Open Filename:="C:\myfolder\myfile.xls"
It could be as simple as Open _ with the space & dash
missing or spelling

"Patrick I" wrote in 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\2004_E _M_Calend
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.


.