View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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