Asked By
ocheng
10 points
N/A
Posted on - 02/15/2012
Hi experts
At the same time as the variables update I want to run VBA codes automatically. Also I have VBA codes in 14 pages. Am I able to write all my macros in one VBA model? By using VBA codes how can I auto run my macros?
Please help.
Thank you.
Â
Running variable updates and VBA codes simultaneously
You have to define the macros where they are going to be used and in what states.
-
If you have the 14 pages all in a same directory server or a folder then it is very easy to access them simultaneously at any time.
-
Just make a new page with a macro that will access all the VBA codes in the 14 pages.
-
Define the type of macro and type of pages when making one.
-
Once done, point the macro to each address of all the 14 pages and save it.
-
Run and it will automatically do the things. The only thing that you need to take care of is that the macro should not get any null value at any point.