question

Upvotes
Accepted
9 0 1 4

batch file to refresh DFO

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?

datastream-apidsws-apibatchdatastream-for-officevbscript
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
53.2k 138 44 63

From the question, I assume that you are using DataStream for Office. If so, please kindly contact the DataStream support team via MyRefinitiv.


1586326475501.png (7.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.