Outputto macro

P

Phil Ferguson

I am exporting to an excel file and do not want to be prompted to replace the
existing file. I would like the file to be autoamtically replaced. How can I
incorporate this into the macro????
 
P

Pete McQuilken

Phil -
In the beginning of your macro (before the transferSpreadsheet action) put
in a SetWarnings action with the "Warnings On" Argument set to "No".
 

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

Word macro that can call cells out of Excel for a find and replace 0
Change a great number of words in word files, with a macro as short as possible. 5
Find and replace macro for Special ^p - MS Word 0
Re-title multiple MS Project .mpp files at once 0
Images are pixelated when saving to PDF 0
Removing a repeated words 0
Improving Macro That Keeps First Letter 0
Need Help with Macro Security 1

Top