Thanks works great


"Lee Hunter" wrote in message
...
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