Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Errors when embedded in a browser.
I have a workbook with a few charts and lots of VBA code to do some
fancy stuff. Everything works as expected when I open the workbook in Excel, but when I open it in IE I get an error 400. Most of the error 400's that I've gotten I've worked around, but there one that I can't think of a work around for. It occurs when I try to active a chart object within a macro. The macro is run when a shape in different chart is clicked. What is this error 400? What does it mean and why would it be occuring in this situation? Thanks James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Errors when embedded in a browser.
I forgot to add something.
In debug mode, if I add a watch to the Worksheets("Charts").ChartObjects(chtName) which is the chartobject I'm trying to activate the value is <Method 'Worksheets' of object '_Global' failed Any insight into what this means and why it only happens in IE? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Errors when embedded in a browser.
I've just noticed that doing either
ThisWorkbook.Worksheets("Charts").ChartObjects(cht Name) or just ChartObjects(chtName) allows the watch to work properly. However, in debug mode rather than getting the 400 error I get a System Error &H80010108 (-2147417848): The object invoked has disconnected from its clients This just confuses me more... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is a web browser | Excel Discussion (Misc queries) | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Object Browser Help | Excel Programming | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
BROWSER | Excel Programming |