Universal Macros?

[Andrew]

I have a file that I export to excel and I need to constantly reformat the
cells etc. I recorded a Macro for the formatting but everytime I export it
again the macro isnt there. How to I record a macro and make it available to
any document in excel?

Thanks

 

[Bernard Liengme]

Put the macro in PERSONAL.XLS. This hidden file gets opened every time you
start Excel.
Bernard

 

[Dave Peterson]

This doesn't quite sound universal to me. If it were a macro that I wanted
available for all my workbooks, then I'd put it in my personal.xl* workbook.

But for these type things, I put the macro in a separate workbook. I start a
new workbook, I turn on the macro recorder and import the file. I format the
data the way I want and then turn off the recorder.

Then I go back and tweak the code (to get rid of .select's and to make sure the
range addresses aren't hardcoded).

Then I plop a giant button from the forms toolbar onto the only worksheet in
that "macro" workbook. I add some instructions (to remind me what it does) and
then save that workbook.

When I need to import that data, I'll just open that workbook and click the
button.

 

[Andrew]

How do you put it in the personal.xls? When I record it where does it go?
Thanks