I have used this instruction:
But it showed up that I can’t open in Excel file that has been generated.
I have the following situation:
- I need daily data refresh in excel (tabel in excel with external data connection)
- I have connected this table through Microsoft Query (ODBC) to Oracle database
This is how it works now:
- I’m running script each day (it creates table with needed data from other tables)
- opening excel file and refreshing table in excel and pivots etc
After Execute command I have used “Run program” in Toad and simple vbs script.
Arguments:“E:…path to script.vbs”
SIMPLE SCRIPT BELOW:
Set objExcel = CreateObject(“Excel.Application”)
SetobjWorkbook=objExcel.Workbooks.Open(“H:\path to excel file template with macro .xls”)
objExcel.visible = true
objExcel.Run “macro name”
Mayby it will help somebody.