Posted to microsoft.public.excel.programming

Kalpesh[_2_] Kalpesh[_2_] is offline

external usenet poster

Posts: 15

ActiveWorkbook.SaveAs problem

Sandy

How about ActiveWorkbook.SaveAs Filename:= _
"R:\Cost\Development\Requote\" + mtxtSaveName + ".xls",

Here, it will replace the value of mtxtSaveName with the content of the
variable

Does this help?
Kalpesh

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'ActiveWorkbook.SaveAs Filename'	TOMB	Excel Programming	2	February 15th 05 11:51 PM
ActiveWorkbook.SaveAs Problem	SowBelly	Excel Programming	4	August 4th 04 10:58 PM
activeworkbook.saveas - saving format changes	tk3	Excel Programming	3	August 2nd 04 05:14 PM
activeworkbook.saveas	J Silver	Excel Programming	0	June 25th 04 09:01 PM
Error on ActiveWorkbook.SaveAs method	cruisy	Excel Programming	3	May 17th 04 08:40 AM

All times are GMT +1. The time now is 09:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us