Running variable updates and VBA codes simultaneously

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.

 

• Status: Open
• Question Views: 944
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MultiMedia Applications

Answered By Michelle Bang 55 points N/A #98316

Running variable updates and VBA codes simultaneously

You have to define the macros where they are going to be used and in what states.

1. 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.
2. Just make a new page with a macro that will access all the VBA codes in the 14 pages.
3. Define the type of macro and type of pages when making one.
4. Once done, point the macro to each address of all the 14 pages and save it.
5. 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.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 03/04/2012
• Question Category: MultiMedia Applications