Visual Basic returning error '438' when writing a value to Internet Explorer

**srbloom** · 01-26-2009, 06:09 PM

Hello,

I am trying to read a value from an excel sheet and write it to a form in an Internet Explorer window. Here is my code:

Sub innernet()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.Application")
    IE.navigate "http://drdoctor.cropsci.uiuc.edu/smallRNA.php"
    IE.Visible = True
    While IE.busy
        DoEvents  'wait until IE is done loading page.
    Wend
    IE.Document.all("form1").Value = Workbooks("myworkbook.xlsx").Worksheets("AllSoy").Cells(3, 3).Value
    IE.Document.all("submit").Click
End Sub

The program works up until the 2nd to last line of code (IE.Document.all("form1").Value = ......) which is when it throws me run-time error '438': "Object doesn't support this property or method".

I am unsure of what is wrong here, and documentation on this topic seems scarce.

Thank you.

**Leith Ross** · 01-26-2009, 06:15 PM

Hello srbloom,

What is "Form1"? Is this an input box, table, what?

**srbloom** · 01-26-2009, 06:26 PM

Leith Ross,

I take "form1" from going to http://drdoctor.cropsci.uiuc.edu/smallRNA.php and looking at the HTML source code. "form1" appears as the form name and id of the form I am trying to write to.

**Leith Ross** · 01-26-2009, 06:30 PM

Hello srbloom,

The connection is timing out. I will have to try later to see this "Form".

**srbloom** · 01-26-2009, 06:39 PM

It is possible you are not able to access this form publicly. In which case, I have attached a picture of the form on the website.

And here is the accompanying source code:

<html>
<head>
	<title>Small RNA Search</title>
</head>
<body>

<form name="form1" id="form1" action = "smallRNA.php" method="post">
Enter in a small RNA sequence (no more than 50bps) <br />
<textarea cols='55' rows='7' name='seq_text' wrap='off'></textarea>
<input type="submit">
</form>

</body>
</html>

Visual Basic returning error '438' when writing a value to Internet Explorer

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Visual Basic returning error '438' when writing a value to Internet Explorer

Re: Visual Basic returning error '438' when writing a value to Internet Explorer

Re: Visual Basic returning error '438' when writing a value to Internet Explorer

Re: Visual Basic returning error '438' when writing a value to Internet Explorer

Re: Visual Basic returning error '438' when writing a value to Internet Explorer

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions