Login gtalk and chat using VBA excel

[vikas0903]

Hi,
I am trying to write VBA code to login and chat using Excel VBA.
I have used Shell command (as shown below) to open gtalk, but not able to figure out from there.
Shell """" & C:\Users\Google\Google Talk\googletalk.exe & """"

Thanks in advance for your help.

Regards!
Vikas

 

[VBA Geek]

How about using:

Call SendKeys("Your UserName", True)
Application.Wait TimeValue("00:00:01")
Call SendKeys("{TAB}", True)
Application.Wait TimeValue("00:00:01")
Call SendKeys("Your Password", True)
Application.Wait TimeValue("00:00:01")
Call SendKeys("{ENTER}", True)

 

[vikas0903]

Hi VBA Geek,

Thanks for your help. It worked perfectly.
My next step is to select people added to my gtalk list and chat using Excel. Any pointers, how can I do that?

Regards!
Vikas