HTML to Excel

Posted by Kevin on January 12, 2001 8:12 PM

I have seen and used the macros that convert Excel into HTML but is there a simple way to bring a HTML formatted table off a web page into Excel? -- eventually hope to automate the conversion --- Thanks in advance

Posted by Kevin on January 13, 2001 11:08 PM

To bring the contents of a web page HTML table into Excel you can use a web query from Data/get external data/create web query/... but now how do I use VB6 to do this without user input?

Thanks...