#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 190
Default form field

hi,

i was able to successfully use the following code in another website, but a
different website i am testing it on (the myDoc.forms(0).UserName.Value =
strSearch
is the error line being highlighted) yields an error:
"object doesn't support this property or method"

here is my code:

'Variable declarations
Dim myIE As New InternetExplorer 'New '
Dim myURL As String
Dim myDoc As HTMLDocument
Dim strSearch As String

'Set starting URL and search string
myURL = "https://site.login.com/GREATNESS/Logon.asp"
strSearch = "poweruser"

'Make IE navigate to the URL and make browser visible
myIE.navigate myURL
myIE.Visible = True

'Wait for the page to load
Do While myIE.Busy Or myIE.readyState < READYSTATE_COMPLETE
DoEvents
Loop

'Set IE document into object

Set myDoc = myIE.document

'Enter search string on form
myDoc.forms(0).UserName.Value = strSearch
myDoc.forms(0).Password.Value = "test"


how can i figure out whiat the fieldname is, or get closer to making this
work?

thanks in advance,
geebee



Reply
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
Linked excel field from access form field - help required. fishy Excel Programming 1 April 5th 08 02:43 PM
Active X Controls Tabbing from Form Field 2 Form Field Tfrup12 Excel Discussion (Misc queries) 0 February 19th 08 08:15 PM
Reading Access Form Field and Copy to Excel Field KevinKBM Excel Programming 0 July 13th 07 07:16 PM
Copy form field value to another form (calendar) [email protected] Excel Programming 1 December 1st 05 09:58 PM
How do I set up excel to tab from field to field in a form? bigmac6365 Excel Discussion (Misc queries) 2 September 30th 05 08:32 PM


All times are GMT +1. The time now is 08:16 PM.

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

About Us

"It's about Microsoft Excel"