Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 30th, 2008, 12:26 PM
Registered User
 
Join Date: Feb 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default excel write to web java applet form

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.






Similar Threads
Thread Thread Starter Forum Replies Last Post
VB 6.0, use form to write to excel (textbox) bonkbc Beginning VB 6 2 March 3rd, 2008 11:44 AM
close java applet causes browser to crash Thomanji Ajax 0 February 24th, 2006 10:25 AM
java applet trick convet to c# chall3ng3r General .NET 0 February 8th, 2005 11:22 PM
display element (layer) over java applet mateenmohd Java GUI 0 January 6th, 2004 12:39 AM
Plotting a graph on a Java Applet cooldude87801 BOOK: Beginning Java 2 1 June 12th, 2003 08:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.