Save as Activeworkbook but not .xls

[Guest]

Hello.....Everybody
If I want to Save as Activeworkbook by using the same name but Lastname (.xls) I want to use .tmp , How can I do (by Macro Command) .....Thanks

 

[robfo0]

Do you mean like this?

Sub savename()
Application.ActiveWorkbook.SaveAs ("c:filename.tmp")
End Sub

you could also use:

Application.Activeworkbook.savecopyas

to save a copy instead of the actual file. Hope that helps

 

[Guest]

I use this Command but it show Run-time Error 1004 ,How can i do next ?

 

[Guest]

Hello...again
Yes it work perfectly, last time i do something wrong with this command (human error) now it work already ...thank you GUY