Hi All,
I have an excel file which has a couple of objects. These objects actually contain data for use with an addin program (this addin program uses the information to generate data pulls basically). Does anyone know if it's possible to display 'all' the data behind the object in question?
I'm able to view some of the information using the design tool and properties box but there is additional data not shown here. I'm wanting to do this as some of the data needs to be replaced; a simple find/replace actually.
I'm trying to investigate this as I have about 1000 of these objects which all require the same change and the addin program does not provide this find/replace feature.
This is the informaiton I get from the properties box for one of the objects. The extra data I'm looking for is similar to an SQL query (or at least is uses the word 'where' at the beginning!)
(Name) NITRORange12
AltHTML
ApplyCalcOrder False
AutoArrangeDims False
AutoLoad False
CalcOrder 0
ColumnsInRange 28
Database SNACKSSUM
DimCount 4
DimDescription
DimGetString
DimIndex 0
DimName
DimsinColumns 2
DimsInHeadings 0
DimsInRows 2
DisplayStyle 0 - rngTableDefault
DisplayType 1 - ShortDescription
Drillable True
Enabled True
GetDatabaseFrom
GetFormatFrom
GetLayoutFrom
GetTitleFrom
Height 12
Left 0.75
Locked True
MaxSelections 0
MinSelection 0
NAasZero True
Placement 2
PostUpdateMacro
PreUpdateMacro
PrintObject False
Prompt False
PromptForBatabase False
PromptText
RangeDescription NITRO Range 13
RowsInRange 6
Shadow False
Top 166.5
UpdateIndex 16
UseDictionaryFormats False
Visible True
Width 12
Many thanks in advance
RodP
I have an excel file which has a couple of objects. These objects actually contain data for use with an addin program (this addin program uses the information to generate data pulls basically). Does anyone know if it's possible to display 'all' the data behind the object in question?
I'm able to view some of the information using the design tool and properties box but there is additional data not shown here. I'm wanting to do this as some of the data needs to be replaced; a simple find/replace actually.
I'm trying to investigate this as I have about 1000 of these objects which all require the same change and the addin program does not provide this find/replace feature.
This is the informaiton I get from the properties box for one of the objects. The extra data I'm looking for is similar to an SQL query (or at least is uses the word 'where' at the beginning!)
(Name) NITRORange12
AltHTML
ApplyCalcOrder False
AutoArrangeDims False
AutoLoad False
CalcOrder 0
ColumnsInRange 28
Database SNACKSSUM
DimCount 4
DimDescription
DimGetString
DimIndex 0
DimName
DimsinColumns 2
DimsInHeadings 0
DimsInRows 2
DisplayStyle 0 - rngTableDefault
DisplayType 1 - ShortDescription
Drillable True
Enabled True
GetDatabaseFrom
GetFormatFrom
GetLayoutFrom
GetTitleFrom
Height 12
Left 0.75
Locked True
MaxSelections 0
MinSelection 0
NAasZero True
Placement 2
PostUpdateMacro
PreUpdateMacro
PrintObject False
Prompt False
PromptForBatabase False
PromptText
RangeDescription NITRO Range 13
RowsInRange 6
Shadow False
Top 166.5
UpdateIndex 16
UseDictionaryFormats False
Visible True
Width 12
Many thanks in advance
RodP