Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi Expert,
Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi Hidayat
Or you could do a keyword search in the help for constants or write msgbox(constant_name) in a macro = this shows xlDialogZoom as 256.... Regards David "Hidayat" wrote in message ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi Hidayat,
Try the Object Browser within the VBE. From Excel use ALT+F11 to display the VBE (visual basic editor) The F2 to display the object browser. You can then use the search function within the Object Browser. Hidayat wrote: Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat -- Cheers Andy http://www.andypope.info |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hidayat,
I have a little utility that will print out the constants and their values on a separate worksheet, which you sort, print etc. It caters for Outlook, Word, Excel, PowerPoint, Access 2000 and 2002. All you need to do is plug in the Office directory (probably c:\Program Files\Microsoft Office\Office) and you are away. Mail me direct if you want a copy. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Hidayat" wrote in message ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi "Hidayat";
http://download.microsoft.com/downlo...-US/wc0993.exe MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
You can try:
' From the Project menu, select References, and set a reference to tlbinf32.dll Sub OfficeConstantsList() Const OfficeApp As String = "C:\Program Files\Microsoft Office\Office10\excel.exe" Dim x As TypeLibInfo, r, mbr, i As Long On Error Resume Next Cells.ClearContents Set x = TypeLibInfoFromFile(OfficeApp) For Each r In x.Constants For Each mbr In r.Members i = i + 1 Cells(i, 1) = mbr.Name Cells(i, 2) = mbr.Value Next mbr Next r Set x = Nothing Columns("A:A").Columns.AutoFit End Sub MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Can't find the tlbinf32.dll. Help
Greg "Michel Pierron" wrote in message ... You can try: ' From the Project menu, select References, and set a reference to tlbinf32.dll Sub OfficeConstantsList() Const OfficeApp As String = "C:\Program Files\Microsoft Office\Office10\excel.exe" Dim x As TypeLibInfo, r, mbr, i As Long On Error Resume Next Cells.ClearContents Set x = TypeLibInfoFromFile(OfficeApp) For Each r In x.Constants For Each mbr In r.Members i = i + 1 Cells(i, 1) = mbr.Name Cells(i, 2) = mbr.Value Next mbr Next r Set x = Nothing Columns("A:A").Columns.AutoFit End Sub MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi Greg;
In the references list, if you see TypeLib Information, it is the same thing. MP "Greg Rivet" a écrit dans le message de ... Can't find the tlbinf32.dll. Help Greg "Michel Pierron" wrote in message ... You can try: ' From the Project menu, select References, and set a reference to tlbinf32.dll Sub OfficeConstantsList() Const OfficeApp As String = "C:\Program Files\Microsoft Office\Office10\excel.exe" Dim x As TypeLibInfo, r, mbr, i As Long On Error Resume Next Cells.ClearContents Set x = TypeLibInfoFromFile(OfficeApp) For Each r In x.Constants For Each mbr In r.Members i = i + 1 Cells(i, 1) = mbr.Name Cells(i, 2) = mbr.Value Next mbr Next r Set x = Nothing Columns("A:A").Columns.AutoFit End Sub MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Hi Greg; test with this procedure, no reference is necessary:
Sub OfficeConstantsList() Application.ScreenUpdating = False Dim R, Member, i As Long, oPath As String oPath = Application.Path & "\excel.exe" With CreateObject("TLI.typelibinfo") .ContainingFile = oPath Workbooks.Add For Each R In .Constants i = i + 1 Cells(i, 1) = R.Name: Cells(i, 1).Font.Bold = True Cells(i, 2) = "Value": Cells(i, 2).Font.Bold = True Cells(i, 2).HorizontalAlignment = xlRight For Each Member In R.Members i = i + 1 Cells(i, 1) = Member.Name Cells(i, 2) = Member.Value Next Member Next R End With Columns("A:B").Columns.AutoFit Range("A2").Select ActiveWindow.FreezePanes = True Range("A1").Select End Sub MP "Greg Rivet" a écrit dans le message de ... Can't find the tlbinf32.dll. Help Greg "Michel Pierron" wrote in message ... You can try: ' From the Project menu, select References, and set a reference to tlbinf32.dll Sub OfficeConstantsList() Const OfficeApp As String = "C:\Program Files\Microsoft Office\Office10\excel.exe" Dim x As TypeLibInfo, r, mbr, i As Long On Error Resume Next Cells.ClearContents Set x = TypeLibInfoFromFile(OfficeApp) For Each r In x.Constants For Each mbr In r.Members i = i + 1 Cells(i, 1) = mbr.Name Cells(i, 2) = mbr.Value Next mbr Next r Set x = Nothing Columns("A:A").Columns.AutoFit End Sub MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to know the excel's constant
Michael, thank you very much.
Greg "Michel Pierron" wrote in message ... Hi Greg; test with this procedure, no reference is necessary: Sub OfficeConstantsList() Application.ScreenUpdating = False Dim R, Member, i As Long, oPath As String oPath = Application.Path & "\excel.exe" With CreateObject("TLI.typelibinfo") .ContainingFile = oPath Workbooks.Add For Each R In .Constants i = i + 1 Cells(i, 1) = R.Name: Cells(i, 1).Font.Bold = True Cells(i, 2) = "Value": Cells(i, 2).Font.Bold = True Cells(i, 2).HorizontalAlignment = xlRight For Each Member In R.Members i = i + 1 Cells(i, 1) = Member.Name Cells(i, 2) = Member.Value Next Member Next R End With Columns("A:B").Columns.AutoFit Range("A2").Select ActiveWindow.FreezePanes = True Range("A1").Select End Sub MP "Greg Rivet" a écrit dans le message de ... Can't find the tlbinf32.dll. Help Greg "Michel Pierron" wrote in message ... You can try: ' From the Project menu, select References, and set a reference to tlbinf32.dll Sub OfficeConstantsList() Const OfficeApp As String = "C:\Program Files\Microsoft Office\Office10\excel.exe" Dim x As TypeLibInfo, r, mbr, i As Long On Error Resume Next Cells.ClearContents Set x = TypeLibInfoFromFile(OfficeApp) For Each r In x.Constants For Each mbr In r.Members i = i + 1 Cells(i, 1) = mbr.Name Cells(i, 2) = mbr.Value Next mbr Next r Set x = Nothing Columns("A:A").Columns.AutoFit End Sub MP "Hidayat" a écrit dans le message de ... Hi Expert, Does anyone know the value of the Excel constants such as xlDiagonal, xlEdgeBottom etc. How to get that's value..? please advice Thanks for advices Hidayat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel's menu bar | Excel Discussion (Misc queries) | |||
Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
Excel's Save | Excel Discussion (Misc queries) | |||
Excel's TEMPLATE HELP | New Users to Excel | |||
Excel's Dialog Box | Excel Discussion (Misc queries) |