Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MattsConfused
 
Posts: n/a
Default Get External Data in Excel

Hello all,
I'm having a heck of a time trying to use 'get external data' in Excel.

Using Excel 2000. The web page I'm trying to get data from uses cgi and
javascript and the main page has checkboxes on it. Once you select a
checkbox you hit the "search" button in order to get directed to the data
page. Of course, Excel's only catching the url for the first page and when I
browse all the way into the data page I get a message back saying I didn't
check a box inside Excel.

I know there must be a way to get the data. I'm able to cut and paste from
the page into Excel and then manually strip all the html junk but it has
become a very time consuming proposition.

Any help would be greatly appreciated.

The page I'm going to is: http://hud2.towerauction.net/e17/gen_list/IL.htm
and from there check any one (or multiple) checkboxes and click search. The
formatted page that comes up is where I'm trying to get to. I'd like to pull
that data in, strip all the html, remove all pictures etc., and end up with
clean data... ok, easier said than done I know... but isn't that what the
experts are for?!? :)

Thanks in advance for any help!

Matt
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
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
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 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:44 AM.

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

About Us

"It's about Microsoft Excel"