Save at start of month

[Ben Allen]

Hi,
I would like to create a macro so that the first time the spreadsheet is
opened in a month a form is initiated allowing the user to select a
directory, then another allowing the user to select a name, however, that
defaults to "Eurotours-*Month* *Year*.xls
I dont have a clue were to start,
Thanks for your help.
Ben

--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"

 

[arno]

Hi Ben,

just a thought:
it takes me 5 minutes to create the files for the next 5 years. How long
will you need to write your code?

you will need the SaveCopyAs-method for saving. you'd set the month and year
automatically, have the user enter the desired path in a cell of the
worksheet.

Otherwise, you could have a try with SaveAs-method or
GetSaveAsFilename-method.

regards

arno