Hello, I am writing a batch file (vbs) to update the data from DFO programatically. The function in the excel is DSGRID. Although it runs fine, it doesn't seem to update. Here is my code:
Set excApp = CreateObject("Excel.Application")
excApp.Visible = True
excApp.COMAddIns("PowerlinkCOMAddIn.COMAddIn").Connect = True
set wb = excApp.WorkBooks.open("C:\test.xlsx")
excApp.Run "PLRefreshWorkbookEventHandler"
wb.Save
wb.Close
excApp.Quit
Any idea how to make it work?
Hello @ninja
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
From the question, I assume that you are using DataStream for Office. If so, please kindly contact the DataStream support team via MyRefinitiv.
