Sort Excel objects by their creation order
 

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

Sort Excel objects by their creation order
 

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" wrote in message
ups.com...
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

Sort Excel objects by their creation order
 

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