Please refer..Cant we take off the Msgbox and Save by default...

Another way is to Save the file in all cases of vbYes/vbNo/vbCancel

OR

You can also try SENDKEYS() . Refer the below link
http://www.developerfusion.com/code/...automatically/

Please try and let us know

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Dear Expert,

I have written some macros.
Sometimes, it has "save" function.
Then it would pop up a MSG windows asking you "Do you want to save changes
you made to 'MMDEALS.XLS'?

Macro will stop until you click yes or now.

Can VB scripts be written to answer "Yes" automatically ?

Also, If I use "save as", there is a pop up msgbox too.
A file named 'C:\marco\Income_new.xls' already exists in this location. Do
you want to replace it?

Can VB scripts be written to answer "Yes" automatically ?

Thanks so much
Elton