Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
QueryTables/ListObjects and QueryType/SourceType
Both the QueryTable and ListObject Objects have properties (QuertyType and
SourceType) which return constants. Does anyone know where I can find a list of what these constants are? I could not find the on MSDN. Thanks EM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
QueryTables/ListObjects and QueryType/SourceType
The easiest way is to use the object Browser in the VBA window. right click
in the code window and select Object Browser. The put QueryType into the box at the top of the browser and press the binoculars. Then selct the xlquerytype. You will get the symbol names. You can also get the constant values by clicking on each of the types and the constant value will be displayed at the botom of the window. "ExcelMonkey" wrote: Both the QueryTable and ListObject Objects have properties (QuertyType and SourceType) which return constants. Does anyone know where I can find a list of what these constants are? I could not find the on MSDN. Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a list of the listobjects on a worksheet | Excel Programming | |||
Make PivotCaches.Add(SourceType:=xlExternal) from VBScript code | Excel Programming | |||
ListObjects.Add error | Excel Programming | |||
listobjects and querytables | Excel Programming |