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