Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
SHDocVw.InternetExplorer | Excel Programming | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |