Excel Get External Data
 

Morning all,
Currently have Excel2000.
I am using the "Get External data" command in Excel.
For example
In excel hold down the ALT key and type "ddw"
Paste http://www.nswtab.com.au/today/YR04DIVS.HTM
into the dialog box. Click OK OK.
Data comes in sweet.

However paste in
http://newsite.tab.co.nz/racing/
It comes back with error message "Returned no data try editing query"
(ALT_D_D_E)
Tried editing with no joy, can anyone out there overcome this
challenge?

Regards Mick Barry
A horse is carved from a wooden block by removing the bits that don't
look like a horse.


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=507011

Excel Get External Data
 

This may be unrelated, but http://newsite.tab.co.nz/racing/ pulls data
from a number of other sources (explorer shows other websites at the
bottom while the page is loading). Meanwhile,
http://www.nswtab.com.au/today/YR04DIVS.HTM looks like a static site
with no frills, i.e. pictures hosted elsewhere that are hyperlinked,
etc.

Again, it may be unrelated.

n8


--
ThalesNate
------------------------------------------------------------------------
ThalesNate's Profile: http://www.excelforum.com/member.php...o&userid=31037
View this thread: http://www.excelforum.com/showthread...hreadid=507011

Excel Get External Data
 

Thanks ThalesNate
Could be onto something there.
Certainly food for thought.
I was getting worried that I'd never get a reply.
It seems that the replies only go to the easy questions.
Good to see you give it a go.

Regards Mick Barry
Rather than knock on death's door, ring the doorbell and run , he hates
that.


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=507011