Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
How do you tell what are methods, properties, objects for an object
like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
In the Object Browser, You should be able to find ActiveWorkbook in the left
column, then its children will be in the right column. -- Regards, Tom Ogilvy "davegb" wrote in message ups.com... How do you tell what are methods, properties, objects for an object like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
Tom Ogilvy wrote: In the Object Browser, You should be able to find ActiveWorkbook in the left column, then its children will be in the right column. -- Regards, Tom Ogilvy Thanks for your reply, Tom. In my OB, Activeworkbook is only in the right window and the top window. It doesn't appear in the left window. Don't recall ever seeing it there. The left window seems reserves for high level objects. When I do a search for Activeworkbook, the OB highlights "Application", the parent, in the left window. Maybe you're using a newer version - I'm stuck here with Win2000 and Office 2000. "davegb" wrote in message ups.com... How do you tell what are methods, properties, objects for an object like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
No, I was too quick to answer. if you select Activeworkbook on the right,
at the bottom you see ActiveWorkbook As Workbook Workbook is a hyperlink and if you click on it, you get workbook in the left window, selected and the properties in the right; think of it as Workbook/ActiveWorkbook - so essentially what I said, but with addendum. -- Regards, Tom Ogilvy "davegb" wrote in message ups.com... Tom Ogilvy wrote: In the Object Browser, You should be able to find ActiveWorkbook in the left column, then its children will be in the right column. -- Regards, Tom Ogilvy Thanks for your reply, Tom. In my OB, Activeworkbook is only in the right window and the top window. It doesn't appear in the left window. Don't recall ever seeing it there. The left window seems reserves for high level objects. When I do a search for Activeworkbook, the OB highlights "Application", the parent, in the left window. Maybe you're using a newer version - I'm stuck here with Win2000 and Office 2000. "davegb" wrote in message ups.com... How do you tell what are methods, properties, objects for an object like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
Tom Ogilvy wrote: No, I was too quick to answer. if you select Activeworkbook on the right, at the bottom you see ActiveWorkbook As Workbook Workbook is a hyperlink and if you click on it, you get workbook in the left window, selected and the properties in the right; think of it as Workbook/ActiveWorkbook - so essentially what I said, but with addendum. -- Regards, Tom Ogilvy Never thought to try that. Thanks! "davegb" wrote in message ups.com... Tom Ogilvy wrote: In the Object Browser, You should be able to find ActiveWorkbook in the left column, then its children will be in the right column. -- Regards, Tom Ogilvy Thanks for your reply, Tom. In my OB, Activeworkbook is only in the right window and the top window. It doesn't appear in the left window. Don't recall ever seeing it there. The left window seems reserves for high level objects. When I do a search for Activeworkbook, the OB highlights "Application", the parent, in the left window. Maybe you're using a newer version - I'm stuck here with Win2000 and Office 2000. "davegb" wrote in message ups.com... How do you tell what are methods, properties, objects for an object like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
An objects properties?
I use this also:
http://www.vbaccelerator.com/codelib...oc/article.htm NickHK "davegb" wrote in message ups.com... How do you tell what are methods, properties, objects for an object like "ActiveWorkbook"? I can look it up in the Object Browser and see what it's "parent" is, but not what it's "children" are. Is there a reference source that works like the OB in reverse? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the address properties from range objects in a sum formula | Excel Discussion (Misc queries) | |||
Beginer to UserForms question on assigning properties to objects | Excel Discussion (Misc queries) | |||
Width properties of drawing objects | Excel Programming | |||
structure of classes,objects,properties,methodes,events... | Excel Programming | |||
Objects not showing up in VBA properties | Excel Programming |