change filename
I am looking to some VBA script to change the filename BUT without saving at
that moment.
workbook.Saveas can be used but this also saves the file.
I would like to have the generated name displayed as default filename when
the user wants to saveas the excel sheet. (and not the name as it was opened
with)
regards
|