| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import data from website
Hi all,
I need to get a solution for following problem. I need to extract a table from a website, like this http://www.cbot.com/cbot/pub/page/0,3181,1213,00.html and get it into a useful format Already tried it with the usual "import website" functions in Excel, but neither is it working everytime, nor is it possible to add the data instead of overwriting them all the time. At the same time I would prefer it to delete unused rows and cells in the spreadsheet after the import, but this is a minor issue. It would be nice, if the format could look like this in the end. 17-Sep 16-Sep 15-Sep 24964 25131 25519 27450 27350 27200 27450 27350 27200 Every help is appreciated & thanks in advance brgds Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import External data from a Website | Excel Worksheet Functions | |||
| Import data from website everyday at certain time... | Excel Discussion (Misc queries) | |||
| Import data from a secure website to Excel | Excel Programming | |||
| Import data from a website to excel | Excel Worksheet Functions | |||
| How do I import data from a SECURED website into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
