topic Re: Macro to go through many Assemblies to list the names of the subassemblies in 3D Part & Assembly Design https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286546#M3408 <HTML><HEAD></HEAD><BODY><P>Anyone here worked on Macros? ...</P></BODY></HTML> Fri, 31 Mar 2017 08:27:00 GMT ftorabi 2017-03-31T08:27:00Z Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286545#M3407 Hi AllI would like to know, if someone could help me with a macro that could search the names and open them from the windchill database of the models and list the names of all the existing subassemblies in it in a separate file. It would be very helpful for me.Regards Thu, 03 May 2018 03:19:33 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286545#M3407 ftorabi 2018-05-03T03:19:33Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286546#M3408 <HTML><HEAD></HEAD><BODY><P>Anyone here worked on Macros? ...</P></BODY></HTML> Fri, 31 Mar 2017 08:27:00 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286546#M3408 ftorabi 2017-03-31T08:27:00Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286547#M3409 <HTML><HEAD></HEAD><BODY><P>Lots of macros. Typically Excel VBA and AutoIt, Others like to use Weblink, J-Link, Autohotkey, and a few venture down into Windows CMD.</P><P></P><P>If you have Windchill it can create a Report, no need for macros, what will list all the components.</P></BODY></HTML> Fri, 31 Mar 2017 18:51:13 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286547#M3409 dschenken 2017-03-31T18:51:13Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286548#M3410 <HTML><HEAD></HEAD><BODY><P>If you're using Windchill, a Windchill Report can provide this.</P></BODY></HTML> Fri, 31 Mar 2017 18:53:42 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286548#M3410 MikeLockwood 2017-03-31T18:53:42Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286549#M3411 <HTML><HEAD></HEAD><BODY><P>Thank you very much. I tried the report option, but this way I should search every assembly manually, I was willing a more automated way</P></BODY></HTML> Mon, 03 Apr 2017 06:30:35 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286549#M3411 ftorabi 2017-04-03T06:30:35Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286550#M3412 <HTML><HEAD></HEAD><BODY><P>windchill can create a report, but you should search assembly by assembly manually, it can't go automated,&nbsp; thank you for the indications. Do you know how to connect Excel VBA to Windchill ?&nbsp; I don't find any commands on this </P></BODY></HTML> Mon, 03 Apr 2017 06:32:13 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286550#M3412 ftorabi 2017-04-03T06:32:13Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286551#M3413 <HTML><HEAD></HEAD><BODY><P>You need to hire a database programmer to dump the correct tables from Windchill. Even if it could be done with VBA you need a database programmer to get the correct structures.</P><P></P><P>That same programmer could generate the information you are actually after, since there is nothing useful about huge spreadsheets. I expect you are looking to get some result from the data; the programmer can produce that result directly from the more powerful database rather than the weak spreadsheet.</P></BODY></HTML> Mon, 03 Apr 2017 07:27:04 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286551#M3413 dschenken 2017-04-03T07:27:04Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286552#M3414 <HTML><HEAD></HEAD><BODY><P>yes but as you know it's not a common practice to get a programmer to do these tasks. it's something that even an engineer in the office might face to and need to do</P></BODY></HTML> Mon, 03 Apr 2017 07:31:57 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286552#M3414 ftorabi 2017-04-03T07:31:57Z Re: Macro to go through many Assemblies to list the names of the subassemblies https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286553#M3415 <HTML><HEAD></HEAD><BODY><P>Don't tell me what I know. I know what the common practice is. I just told you. Hire a programmer who can handle the job.</P></BODY></HTML> Mon, 03 Apr 2017 07:39:53 GMT https://community.ptc.com/t5/3D-Part-Assembly-Design/Macro-to-go-through-many-Assemblies-to-list-the-names-of-the/m-p/286553#M3415 dschenken 2017-04-03T07:39:53Z