View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron[_2_] Michel Pierron[_2_] is offline
external usenet poster
 
Posts: 63
Default where to find all excel constants?

Ryan, the constants are indexed in the .olb files to the version xl2000.
Using TLBInf32.dll and according to the version of Excel:
Sub ExcelConstantsList()
Dim Version As String
Select Case Val(Application.Version)
Case Is = 10: Version = "excel.exe"
Case Else: Version = "excel" & Val(Application.Version) & ".olb"
End Select
Application.ScreenUpdating = False
Dim R, Member, i As Long
With CreateObject("TLI.typelibinfo")
..ContainingFile = Application.Path & "\" & Version
'...

Regards,
MP

"Ryan H." a écrit dans le message de
le.rogers.com...
Hi,

I'm wondering where I can find all the excel contants listed and their
explanation? For example, I learned a couple of days ago og the xlBlanks
constant, and how to use it to find blank cells. What if I want to find out
if there is such a constant for finding filled up cells. Is there a webpage
out there or a resource I can look up to find these constants?

Thanks