Excel 2007 : Deploying macros in all workbooks

[smudgepost]

After recording a macro, how can I deploy it almost as if it were a plugin so whenever I open a new instance of Excel, I can hit my shortcut key and make it run or easily find the macro and run it?

[teylyn]

Hi,

create the macro in a new file, save the file as personal.xlsb and save that file in

C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART

Then set the file to be hidden (and save it again). The file will now be loaded every time you start Excel, but it will not pop to the foreground because it's hidden. You can still use all the macros that are stored with your personal.xlsb.

hth

[smudgepost]

That's great thanks!

[smudgepost]

Starting a macro.. I wondered if I could make a dialogue to load a file, in this macro's instance an xml. As I name them differently I couldn't call the right file, so wondered if I could open excel, run the macro which asks for the right file and then finishes the macro. Is this difficult to do?

[shg]

See the GetOpenFilename method.