Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Templates
Dear ALL,
I am currently using excel for budgeting and forecasting and result analysis. My excel file is big with 96 work sheets most of then contain IF, AND etc statements. I am pretty new to macros but I beleive they would help me a great deal. Is there anywhere I can good macro template which i can then use as starting points for the different tasks I want them to do. -- Thanks, TKA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Templates
This might help:
Try using "Record new macro"; you will get a vba code as a result, then try generalize/customize the code, so you get your own macro template. Steps: -1- Select Tools/Macro/Record New Macro. -2- Type in / copy /paste /search .. do whatever you want with your workbook/sheets. -3- Select Tools/Macro/Stop Recording. -4- Press Alt+F11 to launch the VBA editor. -5- Play around with the macro, try changing something in the code. -6- Press F5 to run the macro and see the result. I think the vba code is self-explained; you don't have to know much about vba to create macro templates that perform basic tasks. arunkhemlai "TonyKA" wrote: Dear ALL, I am currently using excel for budgeting and forecasting and result analysis. My excel file is big with 96 work sheets most of then contain IF, AND etc statements. I am pretty new to macros but I beleive they would help me a great deal. Is there anywhere I can good macro template which i can then use as starting points for the different tasks I want them to do. -- Thanks, TKA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Templates
Thanks but I've done this for some simple macros that i use. What I'm
looking for is reference to more advanced macro templates which are difficult or imposible to record. If you can help let me know "arunkhemlai" wrote: This might help: Try using "Record new macro"; you will get a vba code as a result, then try generalize/customize the code, so you get your own macro template. Steps: -1- Select Tools/Macro/Record New Macro. -2- Type in / copy /paste /search .. do whatever you want with your workbook/sheets. -3- Select Tools/Macro/Stop Recording. -4- Press Alt+F11 to launch the VBA editor. -5- Play around with the macro, try changing something in the code. -6- Press F5 to run the macro and see the result. I think the vba code is self-explained; you don't have to know much about vba to create macro templates that perform basic tasks. arunkhemlai "TonyKA" wrote: Dear ALL, I am currently using excel for budgeting and forecasting and result analysis. My excel file is big with 96 work sheets most of then contain IF, AND etc statements. I am pretty new to macros but I beleive they would help me a great deal. Is there anywhere I can good macro template which i can then use as starting points for the different tasks I want them to do. -- Thanks, TKA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Templates
Hi Tony,
I would suggest to by a book first. Start reading and try building your code in simple steps, where the members of this newsgroup will be glad to help. Regards JY "TonyKA" wrote in message ... Thanks but I've done this for some simple macros that i use. What I'm looking for is reference to more advanced macro templates which are difficult or imposible to record. If you can help let me know "arunkhemlai" wrote: This might help: Try using "Record new macro"; you will get a vba code as a result, then try generalize/customize the code, so you get your own macro template. Steps: -1- Select Tools/Macro/Record New Macro. -2- Type in / copy /paste /search .. do whatever you want with your workbook/sheets. -3- Select Tools/Macro/Stop Recording. -4- Press Alt+F11 to launch the VBA editor. -5- Play around with the macro, try changing something in the code. -6- Press F5 to run the macro and see the result. I think the vba code is self-explained; you don't have to know much about vba to create macro templates that perform basic tasks. arunkhemlai "TonyKA" wrote: Dear ALL, I am currently using excel for budgeting and forecasting and result analysis. My excel file is big with 96 work sheets most of then contain IF, AND etc statements. I am pretty new to macros but I beleive they would help me a great deal. Is there anywhere I can good macro template which i can then use as starting points for the different tasks I want them to do. -- Thanks, TKA |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Templates
Tony,
Check out this link on similar topic: http://groups.google.co.uk/groups?hl...%2Bjen ny%2Bg. "TonyKA" wrote in message ... Dear ALL, I am currently using excel for budgeting and forecasting and result analysis. My excel file is big with 96 work sheets most of then contain IF, AND etc statements. I am pretty new to macros but I beleive they would help me a great deal. Is there anywhere I can good macro template which i can then use as starting points for the different tasks I want them to do. -- Thanks, TKA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saved templates opening as templates | Excel Discussion (Misc queries) | |||
templates | Excel Discussion (Misc queries) | |||
Templates | Excel Discussion (Misc queries) | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
templates | New Users to Excel |