Linking from Excel to Internet.

[basil3legs]

I know it is quite easy to import tables etc. from websites into Excel, however is it possible to get an Excel 2000 spreadsheet to act as a form and send information back to a website? As it needs to act as a form, I can't put variables/values at the end of an HTML address.

Thanks in advance.

 

[basil3legs]

The code I currently have is:

Sub Button1_Click()

ActiveWorkbook.FollowHyperlink Address:="

http://10.0.0.169/formsent.asp",

NewWindow:=False, ExtraInfo:="partcode=ABC", Method:=msoMethodPost

End Sub

(The main lines are all on one line)

but the extrainfo does not go across. If I use the msoMethodGet then the ExtraInfo is attached to the end of the URL but nothing gets done with it using msoMethodPost.

Can anyone see what I am doing wrong?