Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I sort excel 03 sheet by date order? | Excel Discussion (Misc queries) | |||
Iterative creation of Image objects? | Excel Programming | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Naming objects on creation | Excel Programming |