in reply to
Re: Set Excel file name (without saving!)
in thread Set Excel file name (without saving!)
Not quite. The workbook is created with $Excel->Workbooks->Add, so the original file name is 'Book1'. I want the user to save the spreadsheet themselves (if they want to), but give them a 'default' name of something better than Book1. So when they do a 'Save As' from Excel, the file is already named correctly; they just need to pick the folder they want to dump it in.
If I can give the Add method a file name without it complaining that the file doesn't exist, that would work also!