ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ErrNum = -2147467259 (https://www.excelbanter.com/excel-programming/293393-errnum-%3D-2147467259-a.html)

Kevin

ErrNum = -2147467259
 
The following code has been running without errors until this morning

Sub GetSharesNow(
On Error GoTo ErrorSu
Range(Cells(14, 8), Cells(24, 8)).ClearContent
Set IE = GetObject(, "InternetExplorer.Application"
sHTML = IE.Document.Documentelement.InnerTex
SubChoice = "GetSharesSub
NotifyGetDataForm.Sho
ErrorSub
ErrorHandle
End Su

UserForm NotifyGetDataForm calls a separate routine that write
sections of sHTML to a worksheet

The program now stops during

sHTML = IE.Document.Documentelement.InnerTex

I've been able to confirm ErrNum = -214746725

Can anyone help me resolve this problem

Thanks

Kevin


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com