Save as Activeworkbook but not .xls

Mar 13th, 2002, 01:06 AM

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 · Mar 13th, 2002, 01:19 AM

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

Mar 13th, 2002, 01:40 AM

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

Mar 13th, 2002, 03:18 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:06 AM	#1
Guest Posts: n/a	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

Mar 13th, 2002, 01:19 AM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	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

Mar 13th, 2002, 01:40 AM	#3
Guest Posts: n/a	I use this Command but it show Run-time Error 1004 ,How can i do next ?

Mar 13th, 2002, 03:18 AM	#4
Guest Posts: n/a	Hello...again Yes it work perfectly, last time i do something wrong with this command (human error) now it work already ...thank you GUY