Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On line:
with Application.FUBAR I get error: Method 'FUBAR' of object '_Application' failed 1. Why doesn't the error respect the VBA statement and say "of object 'Application' failed"? 2. What does syntax '_Object' mean? Thanks. *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In that statement, Application is the Object. VBA sees FUBAR as either a
property or a method of the Application object. In this case, the message indicates it determined FUBAR to be a method and the method cannot execute, ergo, the method FUBAR failed. wrote in message ... On line: with Application.FUBAR I get error: Method 'FUBAR' of object '_Application' failed 1. Why doesn't the error respect the VBA statement and say "of object 'Application' failed"? 2. What does syntax '_Object' mean? Thanks. *** |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks very much, JLGWhiz.
But that's not my question. The question is: Why does the error message say "_Application", not "Application"? What does the underline signify in the expression "_Object"? *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vba syntax | Excel Discussion (Misc queries) | |||
Syntax again for DA | Excel Programming | |||
Syntax help for if | Excel Programming | |||
help with syntax | Excel Programming | |||
SQL syntax | Excel Programming |