PC Review


Reply
Thread Tools Rate Thread

Pivot Table Dynamically Creating on Query

 
 
Brent
Guest
Posts: n/a
 
      18th Mar 2005
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


 
Reply With Quote
 
 
 
 
=?Utf-8?B?TGVlIEh1bnRlcg==?=
Guest
Posts: n/a
 
      19th May 2005
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
>
>
>

 
Reply With Quote
 
 
 
 
Brent
Guest
Posts: n/a
 
      7th Jun 2005
Thanks works great


"Lee Hunter" <(E-Mail Removed)> wrote in message
news:B1E8FB58-1C0B-465D-A985-(E-Mail Removed)...
> 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
>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating pivot table dynamically groupie Microsoft Excel Programming 2 26th May 2009 03:39 PM
Use Pivot Table to Populate another table dynamically Chris Microsoft Excel Discussion 0 4th Nov 2008 11:39 PM
creating a pivot table from 4 pivot tables phyllis W Microsoft Excel Worksheet Functions 0 12th Oct 2008 09:52 PM
Creating a pivot table of a pivot table =?Utf-8?B?YWRhbSBjdXJ0aXM=?= Microsoft Excel Programming 0 26th May 2004 02:46 PM
Probs with creating multiple pivot charts from pivot table Retreatgal Microsoft Excel Charting 2 28th Jan 2004 03:51 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:43 AM.