Hi,

My company uses a cgi-bin within its network to submit information wit
various input and then posts resulting data in IE under the same URL.
know the name of the table that I want to import after the 'results
page has loaded and I can progmattically submit the information neede
on the 'submit' screen, but the URL never changes. So when I try t
create a new query to import my data, it will only recognize the table
on the submit screen! Is there anyway to get around this? I've trie
waiting until the 'results' page has loaded and excel still does no
recognize the tableID that is right there in the source code. Pleas
help! I'm goin insane.

What I have so far is:

Sub webdata()
Dim ie As Object
Dim test As Range
Dim iedoc As HTMLDocument


On Error GoTo 1
Set ie = CreateObject("InternetExplorer.Application")
With ie
.navigate "http://natoth/cgi-bin/eac_project_summary.pl"
.Visible = True
Do While .Busy: DoEvents: Loop ' Loop until page is loaded
Do While .readyState < 4: DoEvents: Loop
With .document.forms("F001") ' form name goes in ()
.project_id_pulldown.Value = proj 'all form values listed below
.xl_or_html.Value = "XL"
.dept_id.Value = "L" & dept
.output_format.Value = "EST"
.submit 'submit form values

End With

End With

<Here I need to import table("projectstatus") to Sheet1.rangeA1


Set ie = Nothing
Exit Sub
1: MsgBox "Unexpected Error, sorry."

Set ie = Nothing



Best Regards,
Mjac

--
mjack00
-----------------------------------------------------------------------
mjack003's Profile: http://www.excelforum.com/member.php...nfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=48356