VBA Code Required

T

TGV

Hi

I need a VBA code which should export the access table to excel file in my
desktop. The table Name is 123, so anyone please provide the VBA code and
guide me how I can set it for a command button.

Thank you,

TGV
 
A

Allen Browne

TGV said:
I need a VBA code which should export the access table to excel file in my
desktop. The table Name is 123, so anyone please provide the VBA code
and guide me how I can set it for a command button.
Click to expand...

See help on TransferSpreadsheet.
 

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

How to export table from outlook into ms access table? 0
Data Entry VBA 4
Example Of VBA SQL Statement 0
vba code help for multiple string searching 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Word VBA for deleting Selected Row 0
Access Manage Attachments linked to a SubForm 0
Excel VBA - Problem with Closing Print Preview 0

Top