Naming new workbook

[Guest]

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]

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

 

[Guest]

Thank you Dave

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