Importing / Linking Dynamic Data or ASP Tables into Excel ?

D

Dan Thompson

Hello, I have been working with the "Get External Data" Feature of excel and
it works great for scraping HTML Tables from websites and linking to them in
your spread sheet I also like the fact that you can use a refresh function to
update data in your spreadsheet that is linked to a HTML table on the
Internet.

My ISSUE is this when I use this feature of excel on a dynamically populated
ASP table it does not work it seems to be unable to grab the data from these
type of tables and since more and more sites these days are converting over
to dynamic data driven websites this wonderfull excel feature seems to be
more and more useless. DOES ANYONE know of any workarounds either via VBA
or some Excel ADD-ON that will scrap ASP tables to excel file ?

Dan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Dynamic data ranges in pivot tables 3
Dynamic scenarios - more than 2 variable using data tables in Exc 0
Dsum and Dmax with structured references 1
Link to excel table which has keys in both row and col headers: isthis possible? 0
What-If with data tables? 1
importing/linking data from an Access 2003 Query to an Excel 2003 2
Drop down menu with Dynamic data 0

Top