Macros common to several workbooks

[Jayen]

I am new to vba. I have a workbook which is basically a csv file with data
from a financial system. I need to manipulate this data but before I do, I
need to clean up the data. I have created macros to do this. I then use the
`clean` workbook to produce reports which are also excel based workbooks.
The contents of the csv file changes every day because I download from the
financial system on a daily basis. I need somewhere else to keep the macros
so that they are stored away this workbook. I also need to be able to invoke
the macros from a menu or something similar. The reports I produce also need
some of these macros so I need to be able to handle things like the path in a
macro, is it possible to have a macro that sets a path for all these
workbooks. Thank you for any help.

 

[Duke Carey]

Record a simple macro - say changing the Font size. In the Recording
options. tell Excel to save it in your Personal Macro Workbook. Excel will
now CREATE that workbook.

In the VBA editor, copy and paste your macros to that Personal.xls file and
save. They;ll be available to ANY file whenever you start Excel

 

[Spiky]

And you can assign them to toolbar buttons or make new menu items for
them under Customize.