migrating VB modules into Office 2003

[mkingsley]

I had about 10 VB modules that would appear in any workbook that I was
using. I had saved them under Personal.xls. When we went to Office
2003 I saved the modules out on the server, intending to migrate them
back into Personal.xls in 2003. Now I can't get them to "stick", and
I've searched for Personal.xls, and I don't see it anywhere. Where do
I save these modules, so that regardless of what spreadsheet I open,
they are available?

As always any help is appreciated.

MK

 

[Guest]

Tools>Macro>Record New Macro
In the 'Store Macro In' pull-down, select 'Personal Macro Workbook'.
Do something on the worksheet. Anything. Moving the cursor one cell is fine.
Stop the Macro.

Personal.xls has just been created.
Take your old macros and paste them into Personal.xls


--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[Dave Peterson]

So you don't actually have these 10 modules in each workbook--they just appear
(or should appear) in personal.xls?

If that's the case, make sure you're saving the personal.xls in the correct
location.

I like to do this.

Open excel
hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter:
?application.startuppath

Make a note of it and store your personal.xls in that folder.

 

[Dave Peterson]

Ps. If you really meant that those modules should appear in each workbook
(difficult to believe, though), then you should create a workbook named Book.xlt
and store it in your XLStart folder.