Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
mickbarry
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
ThalesNate
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
mickbarry
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How can I export data from an Excel form into an external Excel d. vonda Excel Discussion (Misc queries) 1 April 21st 05 01:20 PM
Excel: Use a name with external workbook reference for data valida Fishyken Excel Worksheet Functions 3 March 11th 05 10:24 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 02:45 AM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"