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 a

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

"Arne Hegefors" wrote in message
...
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 a

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!

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,
"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" wrote in message
...
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 a

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,
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 Hegefors" wrote in message
...
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,
"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" wrote in
message
...
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 a

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,

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


--
LFCFan
------------------------------------------------------------------------
LFCFan's Profile: http://www.excelforum.com/member.php...o&userid=37484
View this thread: http://www.excelforum.com/showthread...hreadid=571335