Return the Object that belongs to a CodePage

BruceMutton · Mar 23rd, 2002, 02:32 AM

The opposite of this is easy to do, using

Code:

Object.CodePage

however

Code:

CodePage.Parent

only steps up the VBA object hierachy towards the VBE.

The only way I can think of is by brute force...

Code:

For Each  In ThisWorkbook
  If .CodePage Is  Then
    Msgbox "This is the Object that belongs to the CodePage!"
  End If
Next <>

Any better ideas?

Dave Hawley · Mar 23rd, 2002, 05:04 AM

Hi Bruce

What is a "CodePage" ? Is this a variable you have assigned?

>Object.CodePage

What is the Object?

Ivan F Moala · Mar 23rd, 2002, 05:34 AM

Hi Bruce ....do you mean CodeName ??

eg MsgBox Worksheets(1).CodeName

Ivan

BruceMutton · Mar 24th, 2002, 07:22 PM

Dave, Ivan

Object has the usual VBA meaning. In this case it could be a workbook, sheet or activeX control,

CodePage is is the VBA script associated with the object. All event triggered code is put here by default. eg Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)

and no, CodeName is the "code name" associated with an object, that can be refered to directly in VBA code, without using collection syntax
eg
Msgbox Worksheets("Data") 'using collection syntax
Msgbox Sheet1 'using CodeName

The helpfiles in Excel 2000 are a bit sketchy with regards to VBE objects, Excel97 even more so.

Mar 23rd, 2002, 02:32 AM	#1
BruceMutton New Member Join Date: Feb 2002 Posts: 10	The opposite of this is easy to do, using Code: Object.CodePage however Code: CodePage.Parent only steps up the VBA object hierachy towards the VBE. The only way I can think of is by brute force... Code: For Each In ThisWorkbook If .CodePage Is Then Msgbox "This is the Object that belongs to the CodePage!" End If Next <> Any better ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 23rd, 2002, 05:04 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Bruce What is a "CodePage" ? Is this a variable you have assigned? >Object.CodePage What is the Object?

Mar 23rd, 2002, 05:34 AM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Hi Bruce ....do you mean CodeName ?? eg MsgBox Worksheets(1).CodeName Ivan

Mar 24th, 2002, 07:22 PM	#4
BruceMutton New Member Join Date: Feb 2002 Posts: 10	Dave, Ivan Object has the usual VBA meaning. In this case it could be a workbook, sheet or activeX control, CodePage is is the VBA script associated with the object. All event triggered code is put here by default. eg Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window) and no, CodeName is the "code name" associated with an object, that can be refered to directly in VBA code, without using collection syntax eg Msgbox Worksheets("Data") 'using collection syntax Msgbox Sheet1 'using CodeName The helpfiles in Excel 2000 are a bit sketchy with regards to VBE objects, Excel97 even more so.