html tables

Hi, I have a complicated situation with an unwieldy amount of data. The situation is I have data from my website in excel, each row is a profile (around 100k profiles), that all biographical data is crammed into one data field (or in this case, a cell, since in Excel) in HTML format. The HTML...

The original posting is confusing, asked multiple questions and hasn't generated any ideas/suggestions so .... Let's ask my question a different way. I'm trying to automate IE and have run into a MAJOR snag. Any ideas/suggestions would be appreciated I need to double click a cell in an HTML...

I'm trying toautomate Internet Explorer using Excel VBA. I need to double click a cell within an HTML table.<o:p></o:p> <o:p> </o:p> This lineresults in the proper data so I know I have the correct cell:<o:p></o:p> temp...

Hello, and thanks in advance. Every day I get emailed a table in HTML format. Copy and paste works, but I was wondering if anybody had any clever ideas on how to get excel to do this on its own? The email comes from the same address and the table is 6Rx7C including headers. Thanks for looking!

Hey There, Need help passing html tables from multiple pages from the same website into custom coloumns in an Excel sheet. I attempted using VBA to do this but I failed... Heres the Site:http://www.asx.com.au/asx/research/listedCompanies.do... Each company table has a unique code linked to a...

Hi All I have written a bit of VBA code that opens an IE web browser, navigates to an online database and inputs the search information. Now I would like to take the results (which are in a table) and put them into the spreadsheet. My research so far indicates that the best way to do this...