Pivot Table Dynamically Creating on Query

Is there a command or Vb code to auto create an Excel Pivot Table based on a
query in a database? The database I'm using is not always run in the same
location because of the project it's associated with so I was hoping to be
able to have VBA facilitate the creation of this. Any help would be
greatly appreciated.

Brent

Brent,

record a macro.
DATA - PIVOT TABLE AND PIVOT CHART REPORT
Choose EXTERNAL DATA SOURCE

you're off and running.

Lee


"Brent" wrote:

> Is there a command or Vb code to auto create an Excel Pivot Table based on a
> query in a database? The database I'm using is not always run in the same
> location because of the project it's associated with so I was hoping to be
> able to have VBA facilitate the creation of this. Any help would be
> greatly appreciated.
>
> Brent
>
>
>

Thanks works great


"Lee Hunter" <[email protected]> wrote in message
news:[email protected]...
> Brent,
>
> record a macro.
> DATA - PIVOT TABLE AND PIVOT CHART REPORT
> Choose EXTERNAL DATA SOURCE
>
> you're off and running.
>
> Lee
>
>
> "Brent" wrote:
>
>> Is there a command or Vb code to auto create an Excel Pivot Table based
>> on a
>> query in a database? The database I'm using is not always run in the
>> same
>> location because of the project it's associated with so I was hoping to
>> be
>> able to have VBA facilitate the creation of this. Any help would be
>> greatly appreciated.
>>
>> Brent
>>
>>
>>