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

J

jumpin

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
 
Top