Saving a file with a macro without a path

C

Cmenkedi

I am using 2007 and have developed a spreadsheet template that we use for
various customers. I would like to have input boxes pop up the first time
that the file is saved asking for customer name. I would then like this
passed on to the file name, but we do not save all of the spreadsheets in one
particular folder. Each customer has their folder with sometimes many
different subfolders in each.

My question is:
Can I generate a file name but still have the save-as dialog box pop up to
pick what location I want the file saved to?

Thanks
 
C

Cmenkedi

I have tried your suggestion and everything works except for 2 problems.
1. How do I set up the macro to run whenever save-as is called by the program?
2. I need to save the workbook with macros enabled. I have the right file
extension but it gives me an error message that I will loose the macros.

thanks
 
B

Barb Reinhardt

Do a search for Workbook_BeforeSave. That's where you can do things when
the user attempts to save the workbook. You may not need the other code. I
thought you were going to have them save at another time during execution.

I'm also guessng you are using 2007. If you want to save it as a macro
enabled workbook, save as a .xlsm.
 
C

Cmenkedi

Thank you but I don't want it asking for them every time you save the workbook.
Yes I am using 2007 and have the default file time set to ".xlsm"
 
R

ruic

On the Before_Save block check the existing file name if it is not your
standard file name then the user already save it and you skip your input
boxes.

Unless I'm missing something.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save 1 file to different folders based on cell.value 2
auto run a macro 1
Saving templete / workbook to a specific drive / file 1
Saving a Workbook cause's Error's 7
saving a workbook, naming it and saving it to a specific path 2
Exporting Worksheets from a workbook and saving them as a .prn file 1
Stopping a macro to edit the template then re-saving the macro for use 4
Auto emailing of files 2

Top