How can I read the windchill workspace content (Creo workspace) with VBA program to use the content within excel

[ahogendoorn]

I'm writing a program in vba (excel) to manipulate Creo files and would like to read the contents of the Winschill workspace with VBA

[BineshKumar1 · Accepted solution]

You can use Creo VB APIs. You can install the tool kit for that following the steps mentioned in https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS141739 

The APIs are documented in VB API guide. You should be looking for PTC Windchill Connectivity APIs

We developed a small utility for one of customers, it was more of a standalone client app. But from the experience, it is not very stable and has some performance issues as well

Thanks

Binesh

Barry Wehmiller