Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default 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
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
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
Looking for Excel site similar to "The Word MVP Site" Doug New Users to Excel 1 January 25th 09 12:46 PM
Send and Receive Data From Web Site Into UserForm TextBoxes Minitman Excel Discussion (Misc queries) 0 August 4th 08 05:33 PM
My send to in excel/word does not offer send as attachment Mstink Excel Discussion (Misc queries) 11 March 16th 06 02:49 PM
Variables From TextBoxes SeanEvans Excel Programming 1 September 27th 04 04:20 PM


All times are GMT +1. The time now is 01:12 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"