SaveAs in Macro

[gfkbob]

I am trying to add a 'SaveAs' to a macro so the user must save the
workbook under a different name. I have tried
"Application.getsaveasfilename", "workbook.saveas",
"activeworkbook.saveas". These are not working. Any ideas?

 

[Guest]

This will propt user to save as
Application.Dialogs(xlDialogSaveAs).Show

 

[Sasa Stankovic]

well, it is important to know if you're using xp or 2003 excel...