moving formulas and macros to another wksheet

[saimike]

at work, we have a database which lets us exports pertinent data into an excel file at the click of a button. i do this at least once a day in order to generate a report my bosses. however, i need to do some postprocessing in order to generate the right info which interests them. to do this, i have some macros and formulas. for now, i am manually copying them over to the new .xls created.

is there an easier way to do this?

[MrShorty]

If you store Sub procedures in Personal.xls (and if personal.xls is in the xlstart folder), they will be available to all worksheets. If you store your function procedures in Personal.xls, they, too, will be available to all workbooks if the function call is preceeded by the file name personal.xls.

If you store function procedures in an add-in (myfunctions.xla), they will be available like other built-in functions.

[saimike]

MrShorty,

Thanks for your quick reply. I'd like to clarify 2 things:

- where is the xlstart folder? Is this defined somewhere?

- i have a table with formulas in them that assembles the statistics which one of my bosses find useful. is there an easy way to import this table of formulas into the new xls file (created by the database)?