ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Extract data from web page to specific cells in excel 2003 (https://www.excelbanter.com/excel-programming/296881-extract-data-web-page-specific-cells-excel-2003-a.html)

analogkid12

Extract data from web page to specific cells in excel 2003
 
I am trying to extract data from a web page created with exceleverywhere to
a local spreadsheet on my PC. Basically, the web page is an exact copy of
the spreadsheet on my local drive. The page performs all calculations and I
simply want to have my local spreadsheet update with this info when I open
it. I have tried to use the web query in excel 2003, but it only allows me
to import entire tables, I only need the data from specific cells. Further,
when I do the web query for the table with the data, it only imports some of
the cells, it does not retrieve the data that was manually entered on the
web page.

Any solutions, not sure where to go next...

Thanks in advance




All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com