A
AMDRIT
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.
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.