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