Hello, I am exporting Access 97 data to Excel (using TransferSpreadsheet
etc). Through an Access procedure I am then formatting the data in the
exported file. The problem is that when I run the code, I come up against an
error message on the following line of code:

xlApp.ActiveWorkbook.SaveAs ("filepath")

Elsewhere in the procedure I have avoided using any reference to ActiveCells
etc and the code runs ok, but I don't know an alternative to
ActiveWorkbook.SaveAs. Could anyone please advise? Many thanks in advance...

Tim Long

I have checked that the Excel 8.0 reference is present, have checked that
the file doesn't already exist and have tried clearing every Excel process
using task manager before running the code. All to no avail.