I recently received a new PC at work with XP and Office 2002, With this upgrade, my code no longer works.

In excel right now (since I can't get any further) I am having issues with the Open method.

i even recorded a macro to see if the syntax was different but is wasnt.
Code:
        Workbooks.Open Filename:= _
        "Drive &  Path & Filename.xls"

but it won't work.  Gives an error of :
Run time Error '1004
Method 'Open" of object 'Workbooks' Failed