thanks for the reply RAvi - i am creating a workbook from a macro - the problem is that the new workbook could be called anything from book1 upwards depending on what the user has been doing. i don't want to save the workbook that has been made and can't rename it using
Code:
Name "C:\ABC.xls" as "C:\DEF.xls"
as i don't know what book number it has been created as - is there another way?
can the workbook be created as "Dialup"?
along the lines of
Code:
Workbooks.Add.name="dialup.xls"
i know this code doesn't work as i get the message 'cant assign to read only property' but some function must define the name of a new workbook or you wouldn't get book1, book2 etc