Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Doug
 
Posts: n/a
Default How do I pull in multiple data sets at once?

Hi. Using Excel Office XP. I have a lot of data on webpages that I want to
import. It works great for one webpage at a time to use the Data/ Import
Query/New Web Query. So I how do I do it if I have many webpages? I have
found software to download all the hmtl pages into one folder. Is there a way
to automate the importing of these?

I tried macro, but my skills are weak there, and the macro just opens the
same page each time.

Ideally, I'd like to have the data on each page (they are all alike) put in
one worksheet, just one chunk of data below the other.

Thanks for any ideas!!
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
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM
Drop-down selection fills data across multiple columns Tom Excel Discussion (Misc queries) 7 December 2nd 04 12:43 AM


All times are GMT +1. The time now is 12:48 PM.

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"