Send Report to Word file through VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible in VBA to execute a report, and save it to a word or Excel
file ? I know this can be done through the user interface.
 
rmcompute said:
Is it possible in VBA to execute a report, and save it to a word or
Excel file ? I know this can be done through the user interface.
Click to expand...

You can get the same functionality by using DoCmd.OutputTo. You'll find
the details in the online help. You can't actually save to a Word .doc
file, but you can save to a .rtf (rich text format) file, which
preserves much of the formatting of the report. It won't include lines,
boxes, or graphics, though.
 
Thank you.

Dirk Goldgar said:
You can get the same functionality by using DoCmd.OutputTo. You'll find
the details in the online help. You can't actually save to a Word .doc
file, but you can save to a .rtf (rich text format) file, which
preserves much of the formatting of the report. It won't include lines,
boxes, or graphics, though.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
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

VBA called from Word or Excel or . Function to dDetermin Which 4
Report duplicates 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Word VBA for deleting Selected Row 0
Change unbound text box in Report using VBA language from form 1
Dropping a table from a report 2
VBA and Javascript 4
Automatically cycle through a list of Parameters 5

Back
Top