Need Help Linking Two Modules...

Lidsavr

Active Member
Joined
Jan 10, 2008
Messages
322
I am writing a large VBA program will create over 100 pivot tables and 150 charts when I am through. The code in the first module is nearing its limit and I will need to start coding in a second module soon.

I know there is a way to link to modules together, so when you execute the code it runs straight through because I used the code three years ago at another company that I am not longer with, so I don't have access to the file to peek at it.

Can someone help me out with the code?

Thanks,

Lidsavr
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,416
Not to sound pretentious, but I have to ask if you are replicating 150 times the code that makes each pivot table and chart ? Is that why your code is so long?
 

Lidsavr

Active Member
Joined
Jan 10, 2008
Messages
322
AlphaFrog,
You not being pretentous from my viewpoint.

Yes, each chart has it's own set of code, although each refers back to the first table to save memory. (Same pivotcache)

How do I use less code to do this? (As soon as I am finished with my weekly reports that I am doing manually, I will post a portion of the code and you can see what I am doing.)

Thanks,

Lidsavr
 

Watch MrExcel Video

Forum statistics

Threads
1,132,870
Messages
5,655,712
Members
418,232
Latest member
Hey Nola

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top