SendKeys to open application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I try to open a program from a macro in Excel and login (the Bloomberg
professional, (not the website)) using SendKeys. With some help from other
programmers I got the following code. It does not work at all though and I am
lost. Can someone please help me with this? My problems are:

1) I get error on the WaitFor …line. â€Sub or Function has not been definedâ€
2) If I delete the WairFor line I get error on the
AppActivate("1-BLOOMBERG") line. “Illegal procedure call or argumentâ€


Sub bbg_login()
AppActivate("1-BLOOMBERG")
Application.SendKeys "{BREAK}",false
WaitFor timevalue("00:00:01")
Application.SendKeys "user_Name", false
Application.SendKeys "{TAB}", false
Application.SendKeys "password", false
Application.SendKeys "~", false
End Sub


Any help appreciated!
 
Arne,
"WaitFor" is not Excel/VBA. I suspect Access/VBA but not sure. One way is:
Application.Wait Now + TimeValue("0:00:01")

Also try removing the brackets from the appactivate statement.

SendKeys is always going to be doubtful IMHO.

NickHK
 
Hi! Thanks for your help! Yes SendKeys does not seem to be the most reliable
method. Howver I have trouble finding any documentation on how to do this in
some other manner. To me it seems like a standard procedure but I guess I am
wrong. If you have tips for sites etc. that shows you how to do this using a
better technique than SendKeys I would be most grateful! Thanks alot!

"NickHK" skrev:
 
Arne,
There was the reply to your other post "Active X log in".
I never use this Bloomberg service, so I can't say, but john seems to know
what he's talking about with the Bloomberg control.

NickHK
 
Arne,

If you want to use timers in Excel VBA I always find that
*application.ontime* is much more reliable and flexible. However that
becomes irrelevant as I don't think sendkeys is what you need.

Thanks
Joe
 
Back
Top