Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES | Excel Discussion (Misc queries) | |||
BRAIN BUSTER!! MULTI COLUMN ROW DIFFERNCES | Excel Discussion (Misc queries) | |||
Jargon Buster | Excel Discussion (Misc queries) | |||
Formula Problem - Get your brain around this.. | Excel Discussion (Misc queries) | |||
Use Your Brain | Excel Programming |