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\2004_ E_M_Calen
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.
.