Which Export to Excel Method is Simpler to Implement?

[Heatshiver]

When I did the link manager it tells me it was successfully linked.



The first error, just brings me to the VBA, and I have to comment it out and restart the MDB.
The second error gives me "Run-time error '70': Permission denied", and I then comment out that line.
The third error also gives me "Run-time error '70': Permission denied", and I then comment out that line.

By this time, I can finally click the export button and seemingly it works. However, the Excel file that is outputted is blank.

[June7]

Don't know what the issue is. We are running the same downloaded project.