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.
Conceptually there is no reason why this could not be done as long as the logic for where things are and what precisely you wish to have done is known. A few questions:Originally Posted by kadija
- from where do you wish this VBA procedure to run. VBA is "internal" to an application, not really a standalone language like, say VB or C
- do you want the appl that runs the proc to run "automatically" at some time each day? or will someone manually initiate things?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Posting Permissions
Reply With Quote