LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I sort excel 03 sheet by date order? Mrblandings Excel Discussion (Misc queries) 1 March 12th 08 12:31 PM
Iterative creation of Image objects? [email protected] Excel Programming 2 January 25th 07 11:30 AM
Sort order : Excel vs imported data John Excel Discussion (Misc queries) 0 December 9th 05 01:40 PM
Pls. reply Sort Data and copy to next coulmn when sort order chang shital shah Excel Programming 1 August 19th 05 02:51 PM
Naming objects on creation Andy Excel Programming 3 November 25th 03 12:40 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"