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.