Hello,

can anybody tell me how to use a macro from another excel sheet.
Situation :

I have 1 file called records.xls
This file has to be overwritten every time when filled (export from access).
When this opens I have to start an Excel macro.
How can I use or start a macro which is in my other file : macro.xls (empty
sheet with just a macro in it).
Or any other solution is welcome.

Jeroen

Hi Jeroen,

simply store the macro in your personal.xls or as an add-in.

Regards,
Ivan

Jeroen wrote:
Hello,

can anybody tell me how to use a macro from another excel sheet.
Situation :

I have 1 file called records.xls
This file has to be overwritten every time when filled (export from access).
When this opens I have to start an Excel macro.
How can I use or start a macro which is in my other file : macro.xls (empty
sheet with just a macro in it).
Or any other solution is welcome.

Jeroen

Or just open the file the macro is in, it will be available to run.

Hi Ivan,

how do you mean both, I am pretty new to macro's and excel

Jeroen

"Ivan Raiminius" wrote:

Hi Jeroen,

simply store the macro in your personal.xls or as an add-in.

Regards,
Ivan

Hi Jeroen,

personal.xls is Personal Macro Book offered by macro recorder. This
workbook remains open and you can use all macros recorded or written by
yourself.

Add-in is workbook saved as add-in (*.xla - you can save as it in
Excel). Then in Tools Addins you can install it and have it prepared
for use.

See excel help for more details.

Regards,
Ivan