Re using same macro accross other spreadsheets
 

Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish

Re using same macro accross other spreadsheets
 

Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------

On Jul 12, 4:06*pm, Harish_Sasikumar
wrote:
Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish

Re using same macro accross other spreadsheets
 

On Jul 12, 1:03*pm, Ms-Exl-Learner wrote:
Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------

On Jul 12, 4:06*pm, Harish_Sasikumar
wrote:



Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish- Hide quoted text -

- Show quoted text -

Thanks for the response,Using Personal.xls would activate the macro
for all the excels I use.I just want it to use for the intended
spreadsheets.

Re using same macro accross other spreadsheets
 

What do you mean by "all the Excels I use"?

Is a spreadsheet a workbook?

What do you mean by "activate the macro"?

Can't you re-write the macro to point to whatever workbook is active?


Gord Dibben MS Excel MVP

On Mon, 12 Jul 2010 08:57:06 -0700 (PDT), Harish_Sasikumar
wrote:

On Jul 12, 1:03*pm, Ms-Exl-Learner wrote:
Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------

On Jul 12, 4:06*pm, Harish_Sasikumar
wrote:



Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish- Hide quoted text -

- Show quoted text -

Thanks for the response,Using Personal.xls would activate the macro
for all the excels I use.I just want it to use for the intended
spreadsheets.

Re using same macro accross other spreadsheets
 

I have got more than 500 workbooks.all use the same macro.The problem
arises when I need to change something in the macro, I need to copy
and paste the macro in the editor of all the workbooks.

What do you mean by "all the Excels I use"?
Harish: Its the set of workbooks I


Is a spreadsheet a workbook?
Harish : Yes, its a separate workbook

What do you mean by "activate the macro"?
Harish : basically, I want to call the same macro at all the
places.Even when there is a change in the macro, I should be able to
do it at one place and it should reflect in all the workbooks.






On Jul 12, 8:21*pm, Gord Dibben wrote:
What do you mean by "all the Excels I use"?

Is a spreadsheet a workbook?

What do you mean by "activate the macro"?

Can't you re-write the macro to point to whatever workbook is active?

Gord Dibben * * MS Excel MVP

On Mon, 12 Jul 2010 08:57:06 -0700 (PDT), Harish_Sasikumar



wrote:
On Jul 12, 1:03*pm, Ms-Exl-Learner wrote:
Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------

On Jul 12, 4:06*pm, Harish_Sasikumar
wrote:

Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish- Hide quoted text -

- Show quoted text -

Thanks for the response,Using Personal.xls would activate the macro
for all the excels I use.I just want it to use for the intended
spreadsheets.- Hide quoted text -

- Show quoted text -

Re using same macro accross other spreadsheets
 

As Suggested I have created a personal.xlsm in XLSTART folder
Created the macro,Used hide to hide personal.xlsm spreadsheet.
Called the macro from the required spreadsheets using Application.Run
Application.Run "Personal.xlsm!<macro name"

It works fine.

Thanks to all

-HS




On Jul 13, 9:05*am, Harish_Sasikumar
wrote:
I have got more than 500 workbooks.all use the same macro.The problem
arises when I need to change something in the macro, I need to copy
and paste the macro in the editor of all the workbooks.

What do you mean by "all the Excels I use"?

Harish: Its the set of workbooks I



Is a spreadsheet a workbook?

Harish : Yes, its a separate workbook

What do you mean by "activate the macro"?

Harish : basically, I want to call the same macro at all the
places.Even when there is a change in the macro, I should be able to
do it at one place and it should reflect in all the workbooks.

On Jul 12, 8:21*pm, Gord Dibben wrote:



What do you mean by "all the Excels I use"?

Is a spreadsheet a workbook?

What do you mean by "activate the macro"?

Can't you re-write the macro to point to whatever workbook is active?

Gord Dibben * * MS Excel MVP

On Mon, 12 Jul 2010 08:57:06 -0700 (PDT), Harish_Sasikumar

wrote:
On Jul 12, 1:03*pm, Ms-Exl-Learner wrote:
Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------

On Jul 12, 4:06*pm, Harish_Sasikumar
wrote:

Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish- Hide quoted text -

- Show quoted text -

Thanks for the response,Using Personal.xls would activate the macro
for all the excels I use.I just want it to use for the intended
spreadsheets.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -