I 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
