Exporting Web Page Data to Excel

My first thoughts:

1. It is possible to copy and paste from a webpage to Excel and Excel often places the content in separate cells.
2. You can in-bed a Hyperlink in Excel.
3. You should be able to establish a live link to the webpage.

Tony

i actually wanted to this by a program. I mean, i need to find a way by which an application running on computer reads the data webserver and puts it on a excel sheet itself.

I have written a few programs in VBA, one that collected share prices from a teletext card and updated the prices on my spreadsheet. If you would like a copy, I will see if I can find it. VBA is not intuitive and I record a macro first then copy that and change it.

Provided you have a web feed, I don't think it would be difficult, it's just time consuming learning VBA. One of the advantages of Excel is you can use maths functions in the cells and only use VBA to automate the transfer.

Tony

I'm trying to learn VBA, and have looked for a long time for a method of doing this. If you can find it, I'd like to get the script for it, also. Everytime I try to record the macro, I run into the inability to get it to look at any other slot, or write to any other slot, than the one I started with. Frustrating, because it means I have to go back and edit the macro every time I run it. Not very useful.

Micah

I have found a copy with limited comments, so if you would like a copy please email me at tonyrATvoice.net.au (substitute @). I will email it with a *.jpg extension, rename that to *.xls as my provider won't let me send it otherwise.

Tony

bmadhu_srao

I'm a bit rusty to explain in correct detail but I think this will put you on the right track,

http://www.vertex42.com/News/excel-web-query.html

Happy New Year

hello people, thanks for the response. happy new year