I ran into some strangeness while copying tables from the web to Excel. To demonstrate, I’ll use Debra’s sample data table. I run this code
Sub GetTable()
Dim ieApp As Object
Dim ieDoc As Object
Dim Clip As DataObject
Set ieApp = CreateObject("InternetExplorer.Application")
[...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/02/10/copying-html-tables-over-merged-cells/
Posted
Feb 10 2011, 02:15 PM
by
Daily Dose of Excel