question

Upvotes
Accepted
1 1 0 1

Open Datastream add-in through VBS script

Hi

I have a vbs script scheduled to open anexcel workbook, refresh my data from Eikon, update some charts and send the charts to outlook. Everything works except refreshing the data, this is because the vbs excel instance doesn't have the eikon add-in loaded. Can someone please help me figure out how to load the add-in? I've found lots of threads online but can't piece it together (I'm very to new to VBA!)

This is what I have so far:

Set objExcel = CreateObject("Excel.Application")

objExcel.Application.Run "'S:\file.xlsm'!Module1.Email_charts"

objExcel.DisplayAlerts = False obj

Excel.Application.Quit Set objExcel = Nothing

Many thanks!

eikoneikon-com-api
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

· Write an Answer
Upvote
Accepted
39.4k 77 11 27

See how you can load Eikon Excel COM add-in on this thread.

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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