basil3legs
Programmer
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.
The code I currently have is:
Sub Button1_Click()
ActiveWorkbook.FollowHyperlink Address:=" 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?
Thanks in advance.
The code I currently have is:
Sub Button1_Click()
ActiveWorkbook.FollowHyperlink Address:=" 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?
Thanks in advance.
