Home > Forum Home > Valuing Investments and Businesses > Work with Excel and Bloomberg > distant connection Share

Distant connection

Excel Help for Distant Connection in Valuing Investments and Businesses

Forum TopicLogin

Distant Connection

Rate this:
(3/5 from 1 vote)
OopsOh I forgot. if you want to have the macro at another computer is a bit more tricky. I advise aganist it because it might work in theory but in realy life it will probably hang quite often. you can however connect 2 xls files to each other if they are on the same network. Note that this in practice requires ActiveX. DDE requires that you are logged in to the BB. Doing that from a distant is doable by using SendKeys (but it is only doable in theory since it will work 1 out of 10 times). Needless 2 say I advice against. ActiveX does not require that you are logged in. In sum if you are on the same network it is doable. However mind the legalities involved...
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for distant connection in the