I need to copy content from web table to excel:
Following code is working fine upto Select All -> Paste option, then I get microsoft excel dialog with
"data on clipboard is not the same size ad shape do you want to past any way?"
When I click OK botton the content is copied fine.
only problem is how to handle microsoft excel dialog to click ok.
any work around for this!
<font class="small">Code:</font><hr /><pre> Set cb = CreateObject("Mercury.Clipboard")
Set ExcelApplication = CreateObject("Excel.Application")
Set ExcelWorkbook = ExcelApplication.workbooks.Add
Set ExcelSheet = ExcelWorkbook.worksheets.Add