Thread: ActiveWorkbook.SaveAs problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kalpesh[_2_] Kalpesh[_2_] is offline
external usenet poster
  
Posts: 15
Default 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 QuoteReply With Quote