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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,454
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
 

Forum statistics

Threads
1,181,540
Messages
5,930,505
Members
436,743
Latest member
Cpdennis1

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