TransferSpreadsheet

[Greg]

Within a macro, I am trying to use the TransferSpreadsheet
action to export a table from Access to Excel. When that
step of the macro attempts to execute, I get an
error "Failure creating file."

Any ideas?

I have verified that the file exists and the path is
correct. Thanks in advance.

 

[dennis]

try closing the excel file...then run the macro again and
see if it works this time...