Hello once again,

I am calling save via code as such

if not activeworkbook.saved then activeworkbook.save

in Workbook_BeforeSave, I make a string to be my filename as such

sFileName="C:\Saveme.xls"

Then I call the saveas routine as such

ActiveWorkbook.SaveAs Filename:=sFileName, addtomru:=True,
FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, CreateBackup:=False

And low and behold, nothing happens.

However, when I click the save button from the toolbar, everything works
fine. What is the difference? How can I perform the same save routine as
the button click?

Thanks.