Hi, Im using 2002 and Im 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 Ive explained this clearly

activeworkbook.saveas filename:="whatever that was\" & newname & ".xls"



PraxisPete wrote:

Hi, Im using 2002 and Im 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 Ive explained this clearly

--

Dave Peterson

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