Worked like a charm Tom, thank you!
:-)

Tom Ogilvy wrote in article
...
Try just opening the URL

workbooks.Open Filename:=http://www.someserver.com/somefile

If it puts all the data in one column, just select the data and do
Data=Text to column. This will take you through the text import wizard
after the fact so to speak.

turn on the macro recorder before doing it to get the code.

--
Regards,
Tom Ogilvy