Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send variables to textboxes in a web site
Hello,
http://home.ubalt.edu/ntsbarsh/Busin...raph/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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send variables to textboxes in a web site
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
Looking for Excel site similar to "The Word MVP Site" | New Users to Excel | |||
Send and Receive Data From Web Site Into UserForm TextBoxes | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
Variables From TextBoxes | Excel Programming |