Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm thinking of iterating through cell in a range and dumping/
documenting the value, formula and other attributes into a database so that I can sort, filter, analyse cells. Tried range("a1").properties (i) but properties does not seem to be supported in the object model? Next, I would like to document properties which are different from default - is there some approach to define what is default and then use that as comparison? I thought of looking at the .xlsx XML file but there's Excel specific XML to decipher and to use an XML engine rather than the VBA / Excel Object Model. Any tips? Or any established tools that already do this? Thanks. Ananda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing data: OLE DB and data link properties dialog | Excel Programming | |||
Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Properties transferring from excel cells to word file properties | Excel Programming | |||
file properties with cell data? | Excel Programming |