Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link two spreadsheets and copy cell ref accross row | Excel Discussion (Misc queries) | |||
Macro Textbox accross worksheets - wont work! | Excel Programming | |||
macro help - extra contents of specific columns accross a row | Excel Programming | |||
Printing spreadsheets macro | Excel Discussion (Misc queries) | |||
Sum accross sheets | Excel Programming |