Automated Pivot Generation

**AnthonyWB** · 06-03-2010, 10:04 AM

Hello everyone. I have code written which generates pivot tables. Please see a snipett of the code below:

Please Login or Register  to view this content.

Now here is the deal, rather than have hard coded dates as in

Please Login or Register  to view this content.

I would like to pass a global variable fDate? Any suggestions on how to go about this.

**romperstomper** · 06-03-2010, 10:09 AM

For example:

Please Login or Register  to view this content.

**AnthonyWB** · 06-03-2010, 10:24 AM

Do I declare strDate globally AsString, or within the sub ?

Please Login or Register  to view this content.

**romperstomper** · 06-03-2010, 10:37 AM

Within the sub. Public variables should be avoided if possible - always give variables the least scope they need.

**AnthonyWB** · 06-03-2010, 11:15 AM

I declared the variable locally, however I now have an error that cropps up

Compile Error: Sub or Function Not Defined

Please Login or Register  to view this content.

The AddDataField is highlighted in yellow.

**romperstomper** · 06-03-2010, 11:20 AM

There should be a period in front of it :

Please Login or Register  to view this content.

**AnthonyWB** · 06-03-2010, 11:21 AM

Sorry should be .Add

**AnthonyWB** · 06-03-2010, 11:36 AM

Yep it runs, thanks.

Re: Automated Pivot Generation