If you want Excel to always SAVE, why ask in the first place?!?

But, if you really want the MsgBox, you could do something like:

Answer = MsgBox("Save?",vbYesNo,"Save")
Answer = vbYes

....continue saving here...




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