How do I insert an HTML table into a worksheet

Hi All:

Using VBA in Excel I am trying to insert a table coded in HTML (see below) into a worksheet. If I manually copy the code text to the clipboard and paste it into a cell, the table is displayed with the rows and columns as defined by the HTML tags ... so I thought to do this easily beginning with a string variable, TableVariable, containing the code as follows:

Please Login or Register  to view this content.

Doesn't Work for two reasons ...

1. I am using 64 bit Windows 7 Pro and the MSForms2_0.dll file is missing ... so I can't reference the DataObject Class. Certainly the class is defined in some type library, somewhere, but I haven't found it (except in .NET) and can find nothing about it in VBA on the web.
2. The paste method stuffs all the code into cell A1 and ignores the HTML tags. When I copy and paste the code manually the table is perfect.

If there's a different approach, I am not committed to the clipboard, but can't think of another algorithm. Please help get me on the right track!

Thanks,

Stosh

Here's the HTML code for a 3 X 3 table ...

Please Login or Register  to view this content.