Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
method Worksheets of object _Global failed
Hi,
I'm seeing this run-time error in VB when I use the following code: Dim ws As Worksheet For Each ws In Worksheets ' this line throws the run-time error : I tried using these statements at the beginning of the function ActiveCell.Activate and/or DoEvents or putting a delay, but that didn't help. I also tried using Excel.Application.Worksheets and other ways to use worksheets, but nothing works! The above code is in a VB DLL, which is compiled and installed correctly. This problem happens only when I try to debug my application using visual studio C++. The problem does not happen if I run the application stand-alone or debug it with VB. Any help is appreciated. Thanks, - ND |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
method Worksheets of object _Global failed
Can someone please help with this problem?
More info is that when I put "Application" in VB watch window, I see various objects like: Worksheets : <Application-defined or object-defined error This happens ONLY when I debug my application using visual studio 6 C++. If I dont use C++ as debugging tool, then "Application" looks fine...I'm really stucked !! Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
Method Range of object '_Global' failed | Excel Programming | |||
What does XLS VB Method 'Range of object' _Global failed mean? | Excel Programming | |||
Method 'Range' of object '_Global' failed | Excel Programming |