Export report to rtf, auto overwrite existing file, & NOT open MS

G

Guest

I've been able to set up a macro in Access 2003 to export a report to Word.
However it does two things I don't want:
1 Asks me if I want to overwrite existing file, and
2 Opens MS Word.

How do I enable auto overwrite, and NOT open Word? I tried converting to a
VB module. I could get the module to run properly in design mode but not
when I tried to attach it to a button. I don't know much at all about VB
modules and after my recent experience, don't think I really want to learn
more.

Thanks

John
 
R

Roger Converse

If you have warnings turned off, you will need to have them turned back on.
Otherwise, it will ig nore if there is another file out there.

Thanks,
Roger
 

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

Macro using "Output To" asks to overwrite 1
Overwrite existing file when using OutputTo command 8
export MS Access report to MS Word on separate pages 1
Export report to txt 2
How to delete or overwrite an attachment file 3
VBA to automatically test for file, update, overwrite 3
Multiple TransferText to the same File - Need to Append not Overwrite 2
Export Report to Word Document 1

Top