As I understand it, a workbook does not get a name until it is saved.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"ianripping " wrote in message
...
I want a macro to add a workbook using: -

Workbooks.Add
But then uses a cell (eg A1) to create its name with a descrtiption
afterwards.

Eg a1 = January
Description is " - Monthly Stats"

Any body got the answer?


---
Message posted from http://www.ExcelForum.com/