View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default VBA SaveAs Value

I have a startup macro on one of my worksheets. It has the user input a
batch number into cell a1, and then it saves the file as the batch number.
The batch number is something like 01.ABC.255. When I try to run the macro
listed below, the file saves as a .255 file instead of a .xls file.

ActiveWorkbook.SaveAs Filename:=ActiveCell.Value

I've tried to add text and file extensions after the "value", but cant get
it to work.
Ideally I would like the user to type in 01.ABC.255 and have the file saved
as 01.ABC.255.area1.xls

Thanks