View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vigfus vigfus is offline
external usenet poster
 
Posts: 4
Default How to automate a import from a webpage

Aaaaaarg, i'm stuck...

I know how to make basic functions in Exel, i even made some really
complicated ones, but i think i need another approach to fix this.

I want to import a table from a webpage (easy, just make a webquery that
updates every now and then) then i want to take some of that information and
save to plot a graph, sort of like with the stockmarket.

This is my problem... i don't know how to do this. I need to copy the part i
want to keep progressiveley further away. I don't even know how to automate
the copying of one set of numbers, let alone how to make the procedure
"mobile". This is a graphic explanation of what i want to do:

http://img331.imageshack.us/my.php?i...kmarket8zg.jpg

The red part is the raw data i can fetch automatically. The green is the
part i want to save from each dataset. You can see that i have manually
copied four parts into place and i want to keep pasting the new parts onto
the right of the green area.

Please help. If indeed this is impossible with Excel i would appreciate tips
on what software could do it.

Thank you.