VB6 Coding Help for Internet

[hey yer barred]

Hi All

Where I work, I have to pull some data of a internal internaet site, then copy and paste it from a html page to notpad and then import this into excel. This is taking about 30 mins a day!

I know how to code it to improt into excel, but is there anyway I can get a coding to click the buttons i want on a web page and copy the data i want into notpad.

Im certain the site is all HTML and not java...and the data is always at the bottom of the page, and has 'Result' at the top of the table i want.

Any help is much appreciated!

 

[Norie]

Why do you need to import to Notepad and then Excel?

 

[hey yer barred]

Because if i copy the table from the page into excel..it'll puyt 1 or 3 columns data into one cell!...I have no idea why it does. I cant find a way round it, even with paste special

 

[xenou]

Have you tried a web query from Excel?
Regards.

 

[hey yer barred]

Hi Alexander

I have no idea how to do that...but sounds like it may work...I'll google later and see what I can find.