Querying Properties programmatically
 

Hi there,

I have a question which has been bugging me for some time.

Is there any way to access Properties for any given object programmatically? For example, say I want to store (as I do) all properties for a given cell into a text file so that I can read them back, can you do it?

I wanted to do something like:

Open "properties.txt" for Output as 1
For Each xProp in ActiveCell.Properties
Write #1, xProp.Name; "="; xProp.Value
Next xProp
Write #1, ActiveCell.Properties.Count; " properties found."
Close 1

Which would give something like:

.Value = 0.532657
.Text = 0.533
.NumberFormat = "0.000"
.Width = 18
.Font.Name = "Tahoma"
|
|
170 properties found.

...and so on. I think you get the idea.

I realise the above doesn't work, but what I'm interested to know is if there is an Object that I can use which then exposes the Properties of an Object that follows - perhaps VBE. (something) ... .ActiveCell.Properties that will then enable something like the above to achieve what I desire?

Would much appreciate it if anyone has the answer to this.

Regards,
BizMark