-
Projects:
NameFilenameOutput Type
VBAProject (Sample.xlsm)Sample.xlsm

-
Project VBAProject (Sample.xlsm)

Filename: Sample.xlsm
Language: VB/VBA
Output Type:

-
Properties:
NameValue
FileNameSample.xlsm
FullPathC:\Test\Sample.xlsm
LanguageDescriptionVB/VBA
OutputType

-
References:
NameFilenameDescriptionTypeVersion
VBAVBE7.DLLVisual Basic For ApplicationsActiveX4.2
ExcelEXCEL.EXEMicrosoft Excel 16.0 Object LibraryActiveX1.9
stdolestdole2.tlbOLE AutomationActiveX2.0
OfficeMSO.DLLMicrosoft Office 16.0 Object LibraryActiveX2.8

-
Imports:
Import
VBA
Excel
stdole
Office

-
Files:
FilenameType
Module1Module
Sheet1VBA Document
ThisWorkbookVBA Document

+
File Module1
-
Properties:
NameValue
FileNameModule1
FullPath
SubTypeModule

-
Modules:
NameAccess
Module1Public

-
Module Module1

Name: Module1
Access: Public

-
Declaration:


-
Comment:

'標準モジュール

-
Properties:
NameValue
DocComment'標準モジュール
FullNameVBAProject.Module1
IsShadowsFalse
NamespaceVBAProject
XmlDocComment

-
Structures:
NameAccess
UUIDPrivate

-
Struct UUID

Name: UUID
Access: Private

-
Declaration:

Private Type UUID

-
Implemented Interfaces:

None

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.UUID
IsShadowsFalse
NamespaceVBAProject
XmlDocComment

-
Fields:
NameAccessDeclaration
Data1Data1 As Long
Data2Data2 As Integer
Data3Data3 As Integer
Data4(0 To 7)Data4(0 To 7) As Byte



-
Constants:
NameAccessDeclaration
hEdgePrivatePrivate hEdge As Long
hIESPrivatePrivate hIES As Long


-
Fields:
NameAccessDeclaration
hEdgePrivatePrivate hEdge As Long
hIESPrivatePrivate hIES As Long


-
Methods:
KindNameAccess
FunctionEnumChildProcEdgePrivate
FunctionEnumChildProcIESPrivate
Declare functionEnumChildWindowsPrivate
Declare functionGetClassNamePrivate
Declare functionGetWindowTextPrivate
Declare functionObjectFromLresultPrivate
Declare functionRegisterWindowMessagePrivate
SubroutineSamplePublic
Declare functionSendMessageTimeoutPrivate
Declare subroutineSleepPrivate

-
Function EnumChildProcEdge

Kind: Function
Name: EnumChildProcEdge
Access: Private

-
Declaration:

Private Function EnumChildProcEdge(ByVal hWnd As Long, ByVal lParam As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.EnumChildProcEdge
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindFunction
TypeAliasedNameLong
TypeFullNameLong
TypeNameLong
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndLongByVal
lParamLongByVal

-
Function EnumChildProcIES

Kind: Function
Name: EnumChildProcIES
Access: Private

-
Declaration:

Private Function EnumChildProcIES(ByVal hWnd As Long, ByVal lParam As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.EnumChildProcIES
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindFunction
TypeAliasedNameLong
TypeFullNameLong
TypeNameLong
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndLongByVal
lParamLongByVal

-
Declare function EnumChildWindows

Kind: Declare function
Name: EnumChildWindows
Access: Private

-
Declaration:

Private Declare Function EnumChildWindows Lib "user32" (ByVal hWndParent As Long, ByVal lpEnumFunc As Long, lParam As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.EnumChildWindows
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndParentLongByVal
lpEnumFuncLongByVal
lParamLong

-
Declare function GetClassName

Kind: Declare function
Name: GetClassName
Access: Private

-
Declaration:

Private Declare Function GetClassName Lib "user32" Alias "GetClassNameA" (ByVal hWnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.GetClassName
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndLongByVal
lpClassNameStringByVal
nMaxCountLongByVal

-
Declare function GetWindowText

Kind: Declare function
Name: GetWindowText
Access: Private

-
Declaration:

Private Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" (ByVal hWnd As Long, ByVal lpString As String, ByVal cch As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.GetWindowText
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndLongByVal
lpStringStringByVal
cchLongByVal

-
Declare function ObjectFromLresult

Kind: Declare function
Name: ObjectFromLresult
Access: Private

-
Declaration:

Private Declare Function ObjectFromLresult Lib "oleacc" (ByVal lResult As Long, riid As Any, ByVal wParam As Long, ppvObject As Object) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.ObjectFromLresult
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
lResultLongByVal
riidAny
wParamLongByVal
ppvObjectObject

-
Declare function RegisterWindowMessage

Kind: Declare function
Name: RegisterWindowMessage
Access: Private

-
Declaration:

Private Declare Function RegisterWindowMessage Lib "user32" Alias "RegisterWindowMessageA" (ByVal lpString As String) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.RegisterWindowMessage
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
lpStringStringByVal

-
Subroutine Sample

Kind: Subroutine
Name: Sample
Access: Public

-
Declaration:

Public Sub Sample()

-
Comment:

'Microsoft EdgeをDOM操作(64ビット版Excelでは不可)
'http://www.mvps.org/emorcillo/en/code/vb6/iedom.shtml 参照

-
Properties:
NameValue
DocComment'Microsoft EdgeをDOM操作(64ビット版Excelでは不可) 'http://www.mvps.org/emorcillo/en/code/vb6/iedom.shtml 参照
FullNameVBAProject.Module1.Sample
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindSubroutine
XmlDocComment

-
Parameters:

None

-
Declare function SendMessageTimeout

Kind: Declare function
Name: SendMessageTimeout
Access: Private

-
Declaration:

Private Declare Function SendMessageTimeout Lib "user32" Alias "SendMessageTimeoutA" (ByVal hWnd As Long, ByVal msg As Long, ByVal wParam As Long, ByVal lParam As Long, ByVal fuFlags As Long, ByVal uTimeout As Long, lpdwResult As Long) As Long

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.SendMessageTimeout
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare function
XmlDocComment

-
Parameters:
NameTypeModifiers
hWndLongByVal
msgLongByVal
wParamLongByVal
lParamLongByVal
fuFlagsLongByVal
uTimeoutLongByVal
lpdwResultLong

-
Declare subroutine Sleep

Kind: Declare subroutine
Name: Sleep
Access: Private

-
Declaration:

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

-
Comment:

None

-
Properties:
NameValue
DocComment
FullNameVBAProject.Module1.Sleep
IsAbstractFalse
IsNotOverridableFalse
IsOverloadedFalse
IsOverridableFalse
IsOverridesFalse
IsShadowsFalse
IsStaticFalse
MethodKindDeclare subroutine
XmlDocComment

-
Parameters:
NameTypeModifiers
dwMillisecondsLongByVal



+
File Sheet1
-
Properties:
NameValue
FileNameSheet1
FullPath
SubTypeVBA Document

-
Classes:
NameAccess
Sheet1Public

-
Class Sheet1

Name: Sheet1
Access: Public

-
Declaration:


-
Implemented Interfaces:

None

-
Comment:

None

-
Properties:
NameValue
_CodeNameSheet1
_DisplayRightToLeftFalse
AutoFilterModeFalse
CodeNameSheet1
ConsolidationFunction-4157
Creator1480803660
DisplayAutomaticPageBreaksFalse
DisplayPageBreaksFalse
DisplayRightToLeftFalse
DocComment
EnableAutoFilterFalse
EnableCalculationTrue
EnableFormatConditionsCalculationTrue
EnableOutliningFalse
EnablePivotTableFalse
EnableSelection0
FilterModeFalse
FullNameVBAProject.Sheet1
Index1
IsAbstractFalse
IsShadowsFalse
NamespaceVBAProject
PrintedCommentPages0
ProtectContentsFalse
ProtectDrawingObjectsFalse
ProtectionModeFalse
ProtectScenariosFalse
ScrollArea
StandardHeight18.75
StandardWidth8.38
TransitionExpEvalFalse
TransitionFormEntryFalse
Type100
Visible-1
XmlDocComment


+
File ThisWorkbook
-
Properties:
NameValue
FileNameThisWorkbook
FullPath
SubTypeVBA Document

-
Classes:
NameAccess
ThisWorkbookPublic

-
Class ThisWorkbook

Name: ThisWorkbook
Access: Public

-
Declaration:


-
Implemented Interfaces:

None

-
Comment:

None

-
Properties:
NameValue
_CodeNameThisWorkbook
_ReadOnlyRecommendedFalse
AcceptLabelsInFormulasFalse
AccuracyVersion0
AuthorMicrosoft
AutoUpdateFrequency0
CalculationVersion162913
CaseSensitiveFalse
ChangeHistoryDuration0
ChartDataPointTrackTrue
CheckCompatibilityFalse
CodeNameThisWorkbook
Comments
ConflictResolution1
ConnectionsDisabledFalse
CreateBackupFalse
Creator1480803660
Date1904False
DisplayDrawingObjects-4104
DisplayInkCommentsTrue
DocComment
DoNotPromptForConvertFalse
EnableAutoRecoverTrue
EncryptionProvider
EnvelopeVisibleFalse
Excel8CompatibilityModeFalse
FileFormat52
FinalFalse
ForceFullCalculationFalse
FullNameVBAProject.ThisWorkbook
FullNameC:\Test\Sample.xlsm
FullNameURLEncodedC:\Test\Sample.xlsm
HasMailerFalse
HasPasswordFalse
HasRoutingSlipFalse
HasVBProjectTrue
HighlightChangesOnScreenFalse
InactiveListBorderVisibleTrue
IsAbstractFalse
IsAddinFalse
IsInplaceFalse
IsShadowsFalse
KeepChangeHistoryTrue
Keywords
ListChangesOnNewSheetFalse
MultiUserEditingFalse
NamespaceVBAProject
Password********
PasswordEncryptionAlgorithm
PasswordEncryptionFilePropertiesTrue
PasswordEncryptionKeyLength0
PasswordEncryptionProvider
PathC:\Test
PersonalViewListSettingsTrue
PersonalViewPrintSettingsTrue
PrecisionAsDisplayedFalse
ProtectStructureFalse
ProtectWindowsFalse
ReadOnlyFalse
ReadOnlyRecommendedFalse
RemovePersonalInformationFalse
RevisionNumber0
RoutedFalse
SavedTrue
SaveLinkValuesTrue
ShowConflictHistoryFalse
ShowPivotChartActiveFieldsFalse
ShowPivotTableFieldListTrue
Subject
TemplateRemoveExtDataFalse
Title
UpdateLinks1
UpdateRemoteReferencesTrue
UseWholeCellCriteriaTrue
UseWildcardsTrue
VBASignedFalse
WritePassword********
WriteReservedFalse
WriteReservedByMicrosoft
XmlDocComment