MrExcel.com - Your One Stop for Excel Tips & Solutions

Tom Urtis...

Posted by Bobbi on January 09, 2002 5:30 AM

You helped me previously with the code to create a macro that included the workbook name, date, time, and author. I got it to work - thank you.

My question now is how do I save it so an entire department can access it? Or how can I save it to the personal workbook for use in any workbook on that one machine?

Many thanks.

Posted by Tom Urtis on January 09, 2002 6:04 AM

Hi Bobbi,

Well, the answer depends on how you'd like to apply the code and the nature of the file you are saving. You definitely have options.

Regarding your question about the personal workbook, how that works is that such a workbook stores your frequently used macros in your xlStart directory. That workbook is loaded whenever you start Excel, but stays behind the scenes. You might notice when you try to record a macro, one of the options is to record it to your Personal Macro Workbook. There is on-line help to explain that feature in more detail.

Or, the file may be of the type that needs to be saved as every day or several times a day, or automatically at close. If that's the case, you can plug the code into your Worbook_BeforeClose or AutoClose procedures.

Or, at close, you may want a Yes/No message box asking the user if they want to save the file as today etc., to give them the choice.

Hope this helps to answer your question. The best place to start is understanding what the file is used for, how it is best served by saving it as something, and then utilize the code to those ends.

Tom Urtis

Posted by Chris D on January 09, 2002 12:59 PM

Also, try Dank's excellent suggestion of saving the macro as an add-in : maybe even in your department's shared XLS folders or something

HTH
Chris

>Posted by Dank on January 03, 2002 at 05:43:36:

>Go into normal Excel view.
>Click File, Save As and choose a file type of Add-in. Easy eh?
>You need to be careful that your code doesn't contain any 'Thisworkbook' references. If you find any, change them to ActiveWorkbook.

>Any other probs, let me know.

>Regards,
>Daniel.