I am not new to VB, yet this error is new to me.
I'm running an application that has run for years with no problem. Suddenly, the users are experiencing an error 1004 when this application attempts to open up an EXCEL file, and write to it. Can't figure it out. The file is there, spelled correctly etc..yet the VB AP just can't seem to find it. I even tried to open up a dialogue box, and have the user select that file specifically. When they select that particular file that they want to write to....SAME RESULT. 1004, can't access it.
Is anyone familiar with this error. I'm running VB 6, and EXCEL 2002.

Sure sounds like a security change has removed the user your app is impersonating from that file’s Access Control List.

A group has been removed, its properties have been changed, the file’s list of those who can read it has changed, or the app is now being run under the auspices of a different username.

Thanx Brian.
The common denominator thru all of this is the fact that the clients getting this "1004 Cannot access the file error", have all recently gone thru new PC lease/roll machines. For some reason, the way the new machines are now imaged (XP) leaves them with this message. To install all of the necessary DLLs etc.., I created a setup package with the deployment wizard that has always worked and done the trick. Now with these new machines, they are getting the 1004 message. I have an additional stand alone machine that has VB 6 loaded on it, and I don't get this error. This App is simply a report generator which writes data from an ACCESS db to many, many EXCEL workbooks. None of them are now accessible for these clients thru this App ????

The VB 6 IDE runs with different permissions than an application built from it. Could still be it.

Check the Security log with EventViewer to see if there are any messages that shed light on this.