|
Posted to microsoft.public.excel.programming
|
|
|
Naming new workbook
Thank you Dave
"Dave Peterson" wrote:
activeworkbook.saveas filename:="whatever that was\" & newname & ".xls"
PraxisPete wrote:
Hi, I€„¢m using 2002 and I€„¢m new to VB.
I need to save a new workbook with a file name.
The file name is stored in a variable called NewName
If I code as below
ActiveWorkbook.SaveAs FileName:= _
:\c€¦..\NewName.xls
Of course, the file is saved as Newname.xls and not as the contents of the
variable NewName is there another way ?
Many thanks,
PS I hope I€„¢ve explained this clearly
--
Dave Peterson
|