How do i logon to Datastream automactically with VBA

I have two Add-ins on my excel 1. Datastream , and 2. Eikon

We use Datastream for most of our data. Problem i have is that the datastream would need to be manually turned on when we want the data and then turn off once we got the data before our macro can be run

hence how do i use vba to turn on datastream to get data , and then turn it off before running my other macros ?

ps: i do not want to login Eikon, i have to strictly use datastream

regards

Answers

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    If you have Eikon subscription, which includes Datastream for Office, then your Datastream credentials are tied to your Eikon user account. Therefore in order to use Datastream for Office you need to sign-in to Eikon using Eikon Excel add-in. You can control signing-in to Eikon from VBA using PLSynchronization Manager COM library. See this tutorial.

  • ryeoyh
    ryeoyh Newcomer

    Hi , is it possible to just log on to datastream for office? i.e. if the user has only Datastream on the office, how do i turn datastream on ?

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    I suggest you contact Refinitiv Helpdesk with this question. It's not clear to me which Refinitiv product you're using. And this question does not seem to be related to the use of any Refinitiv APIs, which is what the forums on this portal are dedicated to.