SendKeys to open application

[Arne Hegefors]

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!

 

[NickHK]

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

 

[Arne Hegefors]

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:

 

[NickHK]

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

 

[LFCFan]

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