macduff-
I'm with a new company where previous employees created numerous Toolbox items with catalog p/ns. We are in the process of assigning random, consecutive p/ns and obsoleting the originals. Many of our assemblies are unique, and can be revised during a slow time, so we are only replacing on an "as needed" basis. As we obsolete, we created a component description that shows what it was replaced with. This macro allows me to toggle the description on to replace and then off when completed. It also helps when searching through the tree for specific items, because we use random p/ns. It was just inconvenient the othe way, and we will use it multiple times a day. Sylvia
I'm not really sure. Maybe it's VBA-specific? Program-specific? I'm pretty much self-taught with all this stuff, so there are some pretty large gaps in my knowledge. I do know that the object returned is dependent on what program is running the VBA. For example, if you're using Excel VBA to drive SolidWorks, you can't use Application.SldWorks to get the SolidWorks object. That's pretty much the limit of my knowledge. In the code I posted, I'm not really using it any differently than you are. I just chained a bunch of objects together.
Yeah, normally I do as well. I like to get the IntelliSense (I think that's what they call that dropdown box) help eliminate typos. I just wanted to rib ya about line count. :-D
![[spin]](/data/assets/smilies/spin.gif "[spin] [spin]")