sl8rz

I need to force a save from my VBA code but want to give the user the option of choosing "cancel" from the save box. Right now the code "Me.Save" runs just fine causing the save box to appear. However, since the document has never been given a name (it's from a template) an error will occur if the user clicks "cancel." I need to be able to halt the "Me.Save" command at that point and just dump the document altogether. Any ideas?

Thanks in advance.

zws

You might try inserting a line that reads;

Do while me.save
if me.save = active
then msgbox vbOkCancel
if msgbox = OK then
me.save = true
else
if msgbox = cancel then
me.save = false

or something along those lines. Hope it helps.