LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Web Interface Brain Buster Problem (for me at least :)

This is *VERY CLOSE* to what I need to do, except...

* I need to do it with a Windows app in .NET, not VB6.
* I need to fill in some form elements on an EXISTING IE page, not create a
new one within code.
* I need to then have the IE page given focus.

I've searched far and wide and this is the closest I've seen. Ideas on how
to accomplish in a .NET Windows app and an existing, open IE window?


"kkknie" wrote:


I found the question intriguing so gave it a look. Here's something I
found and tested at the kbb site. Look down to the bottom of the page
to see the word MYEMAIL typed into the form.

Sub HolyCrapThisWorked()

'Dim IE As InternetExplorer '(with reference to internet controls
selected)
'or
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.navigate "http://www.kbb.com"
Do Until IE.readyState = 4
DoEvents
Loop
IE.Document.emailsignup.email.Value = "MYEMAIL"

End Sub

Basically, create an IE object and then just deal with it with client
side VB scripting as if it were a web page. In your case, you would
need to know the name of the form (the one at kbb was emailsignup).

IE.Document.YourFormNameHere.CASE_CALLER_NAME.Valu e = "MYEMAIL"


One advantage would be having some VBScripting knowledge when it comes
to client side scripting in IE.

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=268707


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES Tom Moffatt[_2_] Excel Discussion (Misc queries) 2 June 5th 08 06:48 PM
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES Tom Moffatt[_2_] Excel Discussion (Misc queries) 0 June 5th 08 06:41 PM
Jargon Buster misselainei Excel Discussion (Misc queries) 1 April 26th 06 02:09 AM
Formula Problem - Get your brain around this.. Dominators Puzzle Excel Discussion (Misc queries) 0 February 10th 06 07:21 PM
Use Your Brain Pyball[_7_] Excel Programming 2 December 21st 03 01:08 AM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"