Refreshing Pivot Tables linked to Oracle Datasource
 

I have created a Dashboard Report using Pivot Tables that feed values
to a Top Level spreadsheet. The project necessitates that the report be
auto-scheduled and run daily. Each pivot table is being fed by a query
in Access that is running against an Oracle production enviroment.
There are 28 pivot tables in all. I have written (and scheduled) the VB
script to open Excel and the specific workbook and created the macro to
Refresh all pivot tables in the workbook. What I need now is a way to
authenticate against the Oracle Environment once and refresh all of the
pivot tables in sequence.

Any help would be appreciated.

Marc