Output To Action - Auto Save

[c]

I'm using Output To Action to an excel file. The file overwrites the
existing excel file each time. I'm using scheduler to launch the macro.
unfortunately, I can't seem to get rid of the "Do you want to overwirte the
existing file prompt" so the overwrite doesn't complete if the program is
unattended.

is there anyway to have the output to action auto save without prompting yes
or no? so i can run the application unattended?

thanks, c

 

[Steve Schapel]

C,

There is no way of eliminating the prompt as such. The only way is to
delete the file first. This cannot be done directly with a macro.
However you could make a VBA function in a standard module, and then run
this in your macro, using the RunCode action, prior to your export.

By the way, I would recommend using TransferSpreadsheet rather than
OutputTo.