Help! Output table to Excel File without getting popup

[RDM23]

I am running a macro that will output the file to excel to a set path and file name. I would like this process to just overright the existing file automatically. However, when my macro gets to this part, it prompts me and says current file will be overwritten, press OK to overright, or not to not overright. Is there a way I can eliminate getting asked this so it just automatically overrights the table? Thanks in advance for any assistance.

 

[PHV]

If you used VBA instead of macro you'd play with the Dir function and the Kill instruction.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RDM23]

yeah, I don't know VBA, was hoping to do it with just Access. Thanks.

 

[PHV]

hoping to do it with just Access
Precisely, Access VBA.

 

[pbrodsky]

look at the 'setwarnings' command (in macro) or the docmd.setwarnings command in vba