Help With TransferSpreadsheet

[digital_dawg]

I have an Access database with 4 simular (structure is the same, data and name are different) tables I want to export to Excel. On a form in Access, I have a form with 4 command buttons. I can get 2 tables exported with no problem at all. But when I go to export the other 2, I get the following error:

"The Microsoft Jet database engine could not find the object ". Make sure the object exists and that you spelled its name and the path correctly."

I know this has something to do with file name or path, but I can't find the mistake. When I wrote the code, I wrote the transferspreadsheet code for 1 command button and tested it to make sure it worked. Once I got it to work, I just copied and pasted and changed the names where necessary. It amazes me that 2 of them work and the other 2 don't. This has really got me FRUSTRATED !!

Any ideas ??

Thanks

 

[Travis]

You said that you copied and Pasted the commands and changed the names where necessary

You just introduced the human error factor

What I do to help myself is first open NotePad and copy the line that works and the lines that should be exactly like it right below. I then walk through looking for what is different. Then I verify the differences (even if I don't think they are causing the problem).

My first guess is that the table you are referencing does not exist, next thought is that the Path you are exporting it to does not exist or has another issue that does not let you write to it.