hi could anyone help me out with the below coding on send keys in Excel VBA
I have a excel fiel in cel a1 i have username and password in cell a2
and i have a web page with login texbox and password text box and a submit button
below is my coding.( writing as a module and call it in a button click event in excel )
SUb n(
Range("A1").Select
selection.copy
AppActivate "Welcome to Rediff.com India"
Application.SendKeys ("^V")
End sub
the above coding is only a part when i execute the above the web page gets
activated
But doesnot paste the selected value in the cell a1 and does not show
any error.
kindly assit to correct my coding..
Thanks in advance