kadija
09-09-2005, 10:54 AM
Hi,
I am trying to automate one of the reports that I have.
I am wondering if it is possible to write a VBA script that will be executed on the SQL Server that will open the Excel file, refresh the pivot table and save the updated file.
So the SQL server table gets updated once a day and I want to automatically refresh the excel file that reads from that table when the table gets updated.
Any replies would be appreciated.
I am trying to automate one of the reports that I have.
I am wondering if it is possible to write a VBA script that will be executed on the SQL Server that will open the Excel file, refresh the pivot table and save the updated file.
So the SQL server table gets updated once a day and I want to automatically refresh the excel file that reads from that table when the table gets updated.
Any replies would be appreciated.