How to send variables to textboxes in a web site

[Guest]

Hello,

http://home.ubalt.edu/ntsbarsh/Business-stat/graph/Graph.htm

I want to send variables to this site using Excel. The datas are in the same
cells (for ex, cell "A1" in excel to "J Mon 1" in the website (please look
at the address above), "B1" in excel to "F Tue1 in website... and all datas)

But i did not do something like before.

Is there a way?

Thanks,

Regards,

 

[Randy Harmelink]

You should be able to use the InternetExplorer object from the
"Internet Controls" reference library. For example, something like:

Set oIE = New InternetExplorer
oIE.Visible = True
oIE.Navigate "http://home.ubalt.edu/ntsbarsh/Business-stat/graph/
Graph.htm"
Do: DoEvents: Loop Until oIE.ReadyState = READYSTATE_COMPLETE

Set oForm = oIE.Document.forms(0)
oForm("jan1").Value = Range("A1").Value
oForm("feb1").Value = Range("B1").Value