Excel Macro - Update values: macrodata

October 19, 2010 at 07:48:31
Specs: Windows XP
I saved a Macro in one workbook but want to use it for another workbook. I run the macro and it appears to be running fine until it searches for data in the workbook information is stored. A pop-up box appears and asks me to "Update values: macrodata" and I need to link to the workbook and specific tab information is stored. Is there any way to bypass the 'linking' so that I don't need to reference the macro workbook?

See More: Excel Macro - Update values: macrodata

Report •

October 19, 2010 at 08:26:33
The standard practice for storing macros that you want to be available when any Excel workbook is open is as follows:

1 - Create a workbook named personal.xls
2 - Place your macros in this workbook
3 - Hide the workbook
4 - Save it in your xlstart folder

Any workbook stored in xlstart will open whenever Excel opens. Since personal.xls is hidden, it will open hidden so you won't even know it's there - except that you'll be able to access all of the macros stored in it.

You can get to the macros via the VBA editor, via Tools...Macro...Macros or via a button to which you have assigned the macro stored in personal.xls.

Report •

October 20, 2010 at 11:22:43
Thanks for the tip Derby Dad, however one thing I didn't mention originally is that I need to share this document on the network drive and my colleague also needs access to the macro. Any thoughts?

Report •

October 20, 2010 at 11:32:05
I guess I'm confused.

Without seeing your code, it's really tough to answer your question.

How are you running a macro in one workbook but expecting it to execute instructions on another workbook...unless of course the name of the "other" workbook is in the code itself?

I'm sure I'm missing something, but keep in mind that I can't see your workbook(s) or code from where I'm sitting.

Report •

Related Solutions

Ask Question