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

Bloomberg security

Excel Help for Bloomberg Security in Valuing Investments and Businesses


Forum TopicLogin

Bloomberg Security

Rate this:
(4/5 from 2 votes)
ShockedI think that the issue here would be the Bloomberg security.  If you can login to Bloomberg from the remote machine then this may be possible.

One possibility would be to use VBA code to initiate the Bloomberg login window and then use a Send Keys command to enter the credentials.

VBA Code:
Sub BBlogin()
    Dim BBwindow As Long
    BBwindow = FindWindow(vbNullString, "1-BLOOMBERG")
    If BBwindow = 0 Then
        MsgBox "Error - cannot find Bloomberg login window."
        Exit Sub
    End If
    ShowWindow BBwindow, SW_SHOWNORMAL    
    Application.SendKeys "username", false
    Application.SendKeys "{TAB}", false
    Application.SendKeys "password", false
    Application.SendKeys "~", false
End Sub
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Bloomberg security in the