VBA cannot find Excel file

[Lou_Reed]

The two zipped files show a Excel spreadsheet and a MS Access 2010 db. The form in the db has a button to export the table select to an Excel spreadsheet which must be set up in advance.



The form to do this is already in the db. However, I am getting a error that it cannot find the file. When i click that button it says it cannot find the file and the file is right there and it says that it cannot find the file? I also believe the pass as stated in the source code is correct .

What is wrong?

Any help appreciated.

Respectfully,

Lou Reed

PS. i know that path is particular to my system,but just change it.

[Lou_Reed]

Okay, I think that I have got this one. The file was incorrectly named and typed.

thanks all the same.

Respectfully,

Lou Reed