Is there a way thru which i can get Excel object & collection heirarchy.
B broro183 Feb 27, 2010 #2 hi Anupam I'm not sure exactly what you mean but you may find the Object Browse useful. To see the Object Browser, open the VBE & press [F2] ht Rob
hi Anupam I'm not sure exactly what you mean but you may find the Object Browse useful. To see the Object Browser, open the VBE & press [F2] ht Rob
R Rick Rothstein Feb 27, 2010 #3 I think the number of objects and collections in Excel are too vast to map out the way I think you want to see them. The best I can do for you is these two links... Objects: http://msdn.microsoft.com/en-us/library/bb149081.aspx Collections: http://msdn.microsoft.com/en-us/library/aa272271(office.11).aspx
I think the number of objects and collections in Excel are too vast to map out the way I think you want to see them. The best I can do for you is these two links... Objects: http://msdn.microsoft.com/en-us/library/bb149081.aspx Collections: http://msdn.microsoft.com/en-us/library/aa272271(office.11).aspx