TransferSpreadsheet

  • Thread starter Thread starter Greg
  • Start date Start date
G

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.
 
try closing the excel file...then run the macro again and
see if it works this time...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.ldb extension when file transferred 3
Re: Macro to inport excel file to table in access 2007 2
Too many fields defined 1
Office 2007 TransferSpreadsheet Import 5
TransferSpreadsheet Macro 1
TransferSpreadsheet macro action is not available. 1
NO Transferspreadsheet option in 2007? 1
Transferspreadsheet macro action 1

Back
Top