Sort Excel objects by their creation order

[avi]

Hello,

Is ther in Excel some information about the order (like a date,
hour...) of creation of the different objects (charts and names) that
can be retrieved from VBA?

thanks a lot
Avi

 

[NickHK]

IIRC, objects in these collections are indexed in the order they were
created.
But there would be no correlation between different collections.

You would have to keep track of such info yourself.
If you are doing the creation, this may not be too bad. However, if this
applied to a general WB/user situation, it will become complex very quickly.

Why does it matter ?

NickHK

 

[avi]

Thanks Nick,

As i am not doing the creation, i'll have to find another way.

I'm writing an application that reads all the objects in Excel and
paste them to PDF. The default and logical pasting order should be the
order of creation

Avi

 

[NickHK]

I would assume then that a For Each loop on the collection would return them
in order created.
Curious as why you cannot just print to PDF ?
What significance does the creation time have ?

NickHK