Macro - Saving a report as a .txt

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

Does anyone know how to save a report to a .txt file in a automated kind of
way.... a macro etc.... so i dont have to name it each time etc...

Look forward to your thoughts
 
Does anyone know how to save a report to a .txt file in a automated kind of
way.... a macro etc.... so i dont have to name it each time etc...

Look forward to your thoughts
Click to expand...

Look up the OutputTo method in VBA help:

DoCmd.OutputTo acOutputReport, "YourReportNameHere", acFormatTXT,
"c:Path to document\DocumentName.txt"
 
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

Import and Append of txt files 1
Import txt-files using Wild-cards in file_name 6
Export Table Records to txt file 1
Create a txt file from access 2
Save Report as a .bat 3
Save Report to Hard Drive 1
How to Create a Macro to Import External Data 0
Word macro to save files as .txt 2

Back
Top