Want to save a file with part of the name derived from an inputbox

Hello all,

Maybe you can help me with this. I am looking to create a macro that will create a new periods worth of spreadsheets. This will open the template file, and do a save as for the new name. I am wondering if I can make it so that it will take the current file name:

Example: C:/data/rev/account 2130/account 2130 Template.xls

And I would want it to do a replacement of Template in the file name, to whatever the value in cell A1 is. I have an imput box, where the user will input the month name into the box, it will save to A1, and then I would use that to change the file names. Is that possible?

If it is easier, I can change the name of the files to exclude the template name, and just use the data to append the name, prior to .xls.

Any thoughts? Suggestions?

Your syntax helped immensely. I tweaked it for what I was looking for, and this was what I ended up with, which works great!

Please Login or Register  to view this content.