command to auto export to text or excel

L

ld-runner

i would like to be able to create a macro or VB script that woud accomplish
this;
a very small access DB needs to be exported to excel or txt on a single
command bar button click. I could try to train the users to use the export
feature, but that seems like to much trouble. It would like to create a
custom toolbar with an icon or clickable word that would take the current
data and dump it into an excel or txt file to a specified directory with no
other users intervention required.
Thanks
 
S

Steve Schapel

ld-runner,

You would use a TransferText action in your macro to put the data into a
text file, or a TransferSpreadsheet action to put it into an Excel 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

Copying data into new text file with script 0
Outlook main UI edit needed, report spam button creation... 0
filtered form to export to excel and excel row format as text 0
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Exporting to Excel from Access 3
Export Query to Excel command code HELP 2
Command button for Analyze it with MS Office Excel? 2
Export to Excel with form Progress Bar 2

Top