ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SHDOCVW in Worksheet (https://www.excelbanter.com/excel-programming/354654-shdocvw-worksheet.html)

Dag

SHDOCVW in Worksheet
 
Help I am having issues adding a webbrowser on a worksheet. The object gets
created ok and I can browse but, when I switch to a different worksheet Excel
gets an exception error and closes. I seems like it works ok for small
webpages but bigger ones blow up excel.

I am running Excel 2003 and IE6 sp2

Here is the code I am using:

Function testWebFunc()
Dim browawe As New SHDocVw.InternetExplorer
Set browawe = ActiveSheet.OLEObjects.Add(ClassType:="Shell.Explo rer.2",
Link:=False, _
DisplayAsIcon:=False, Left:=0.75, Top:=50,
Width:=Application.ActiveWindow.Width - 50, Height:=2000 _
).Object
browawe.Navigate "http://google.com"
End Function



All times are GMT +1. The time now is 08:55 AM.

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