http://www.bmreports.com/servlet/com...09-26&param6=*

I'm writing a macro to get external data into a spreadsheet using a iqy
file. the data is there but keeps coming back with no data returned

I ran this:

Sub GetData()
Workbooks.Open
"http://www.bmreports.com/servlet/com.logica.neta.bwp_PanBMDataServlet?param
1=T_DRAXX-5&param5=2004-09-26&param6=*"
End Sub

and it brought back all kinds of data.

xl97.

--
Regards,
Tom Ogilvy

"Astraweb.com" wrote in message
...

http://www.bmreports.com/servlet/com...09-26&param6=*

I'm writing a macro to get external data into a spreadsheet using a iqy
file. the data is there but keeps coming back with no data returned

Thankyou for the reply.

I'm using excel 2000. Tried the code and only got blank a blank page!


"Tom Ogilvy" wrote in message
...
I ran this:

Sub GetData()
Workbooks.Open
"http://www.bmreports.com/servlet/com.logica.neta.bwp_PanBMDataServlet?param
1=T_DRAXX-5&param5=2004-09-26&param6=*"
End Sub

and it brought back all kinds of data.

xl97.

--
Regards,
Tom Ogilvy

"Astraweb.com" wrote in message
...

http://www.bmreports.com/servlet/com...09-26&param6=*

I'm writing a macro to get external data into a spreadsheet using a iqy
file. the data is there but keeps coming back with no data returned