Hello everyone up to this point ive been able to just read everyone post and get my answers not bad for programing for about 3 years now. I have came across a real stumper wondering if anyone can offer some help or solution.
I know how to fill out an html web form using vba excel however now i have an oracle web form that i like to do the same thing and i can't figuere out for the life of me how do to do it beside sending keys to the active screen. here is the code i use yet is unreliable because if you change focus from that screen then the send keys get send to the screen you set focus to.
VBA:
Code:
Sub Test1()
Set IE = CreateObject("InternetExplorer.application") 'create the i.e exploer
IE.Visible = True
IE.Navigate ("there would be a link here but not allow to post") 'navigates to the website
Dim MyAppID, ReturnValue
Do
If IE.ReadyState = 4 Then 'checks is the page is finished
Exit Do
Else
DoEvents
End If
Loop
Ttabing
Wwating
End Sub
Sub Ttabing()
Dim MyAppID, ReturnValue
'AppActivate "Microsoft Word" ' Activate Microsoft
Wwating
AppActivate "Oracle Developer Forms"
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 1.5
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
SendKeys ("RUSS")
Wwating
SendKeys ("{TAB}")
Wwating
SendKeys ("RUSS")
Wwating
SendKeys ("{ENTER}")
Wwating
SendKeys ("HI")
End Sub
' this is wating function
Function Wwating()
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 1.5
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
I guess my ultimate question is how do i make a reference to a web application since it does not download any dll's and does not run on an html page. Hope someone has come across this before so far i have had luck finding anything like this.
excel write to web java applet form
