How to export different table to different sheet of 1 excel file

K

Ken Snell \(MVP\)

If you export a table or query to an existing EXCEL file using
TransferSpreadsheet (macro or VBA), and the first 31 characters of the table
or query do not match the name of any existing worksheet in that EXCEL file,
ACCESS will create a new worksheet in that file.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Link a text box based on drop down box with four options MS Word 365 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
VBA Coding Help for Beginner 0
Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Excel - Wich Function should I use? 1
Embed the same Excel multiple times 0

Top