Hello folks..

I'm trying to get text from a html form, and store the information into
a variant, or just place the information as text in a cell...

Could anybody help me?

Thanks for advance.

Where is the HTML form ? On the web? Local File? String variable ?

Best approach is to load the page in IE and then use the Document Object Model to access the element of interest.

Eg;
Msgbox objIE.document.forms(0).elements("txtInput").value

Plenty of past posts on this in this group: search in google groups for "automate IE"

--
Tim Williams
Palo Alto, CA


"josuegm" wrote in message oups.com...
Hello folks..

I'm trying to get text from a html form, and store the information into
a variant, or just place the information as text in a cell...

Could anybody help me?

Thanks for advance.

I'm loading the page using this:

Dim oBk As Workbook
link = Cells(i, 27).Value
Set oBk = Workbooks.Open(link)

As you may know, this code place the information from web on excel...
There is an information required for me, which is placed inside an html
form... I tried using something like HTMLText.value, and it worked...
but only if I place this information in the HTML Form code... And I
can't call this module... An error like "Macro not found" or something
appears...

Try loading the page into IE and getting the value from there.
Search google groups on "automate IE".

Eg:
http://groups.google.com/group/micro...32064e785f9e00


Tim

josuegm wrote:
I'm loading the page using this:

Dim oBk As Workbook
link = Cells(i, 27).Value
Set oBk = Workbooks.Open(link)

As you may know, this code place the information from web on excel...
There is an information required for me, which is placed inside an html
form... I tried using something like HTMLText.value, and it worked...
but only if I place this information in the HTML Form code... And I
can't call this module... An error like "Macro not found" or something
appears...

Man, I did what you told me to do, but the great majority of posts are
about sending data from Excel to a web page... And what I want is
exactly the opposite...

There's an evil witch flying around my purposes... Goddamn... I found
out a way to get the same information from the website, and this one is
not placed in a HTML Form... But, oh my... The path where there is this
information has more than 255 characters...

Is there any way to fool excel and make it open a path with more than
255 chars??

What you want may be opposite from other posts, but adapting existing code would be simple.

put data in web page:
oIE.document.getElementById("someInput").value = someVariable

get data from web page:
someVariable = oIE.document.getElementById("someInput").value

Not so tricky.

--
Tim Williams
Palo Alto, CA


"josuegm" wrote in message oups.com...
Man, I did what you told me to do, but the great majority of posts are
about sending data from Excel to a web page... And what I want is
exactly the opposite...

There's an evil witch flying around my purposes... Goddamn... I found
out a way to get the same information from the website, and this one is
not placed in a HTML Form... But, oh my... The path where there is this
information has more than 255 characters...

Is there any way to fool excel and make it open a path with more than
255 chars??