Export do Excel

A

A. L. Cµnha

Hi
I want create a macro that export data to Excel, with a filename that is
variable, but automatic.
The filename can be de data in a field of the table.
Thanks.
 
G

Guest

Use the TransferSpreadsheet" Action in the Macro with the
file name coming from a form

=[Forms]![NameOfForm]![NameOfTextbox]

Jim
 

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

VBA - exporting serial letters to single documents 0
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Sorting and filtering text 0
Images are pixelated when saving to PDF 0
How to export html text as word document with specific size and orientation 0
Embed the same Excel multiple times 0

Top