Hi!
Every night I have a macro that is supposed to run and open and login to a program (the Bloomberg professional) and download some data. My problem is the log in process from my macro. Now I use SendKeys but that seems VERY unreliable. Does anyone have any links with code that shows how to use some better techniques e.g. Active X to log in to a program
Any help appreciated! Thanks a lot in advance!

Log in with Active X
Gomez9999
AndersBank,
Logging into any program is conceptually the same process, enter a user name and password, lookup the user name in an identity store (database) and check the passwords match, and set a flag that says the user is authentic. However, behind the scenes each application/web site could do this all sorts of different ways.
Security at the inital login of any application tends to be fairly high, all the methods involving the login should be well protected to stop crackers automating dictionary attacks. Trying to automate a login into an application could be used for bad as well as good.
It sounds like bloomberg are fairly large institute. If their information comes from the tinternet to the application then they might have a web service that you could use. I wouldn't be surprised if bloomberg didn't have api's to let people develop their own software that feeds from bloombergs online data.
You'll need to dop a bit of research on their site, and see what tools and api's they offer. They looked to have a few but it wasn't obvious to me which one you needed to use.
MisterT006
cbpd86
Hi AndersBank,
Thats a difficult question to answer as I am not familar with Bloomberg Professional, however I had a look on Bloombergs site and there are all sorts of API's and addins available.
There is an Excel addin here....
http://about.bloomberg.com/software/info_api.html
Is that what your using... is it any help
I don't even know what Bloomberg do, is it flower arranging
Soumya B
Hello,
I am trying to overcome a similar problem with our Payroll website whereby employees can access their pay data. I am sure with time I will get around the sign in problem.
Would it be possible for me to get a sign in for Bloomberg (whatever that may be !!) so that I can experiment .
What is the website that you are trying to access
ChasAA
Robert Kozak