Export Data to Excel

[TotoB]

Hello everybody,

First of all, I would like to apologize for my English

My main project is to generate automatically a list of
all the parts, assemblies (which are in folders and sub-
folders) in an Excel sheet.
For each line, tell if there is a drawing of this file
and some information about this drawing (format, drawer
etc... which are always in the same place in the drawing)
Right now it's working for Catia, I have done a macro on
Excel to generate a basic list of files, and a macro on
Catia to open all the drawings, take the information
wanted and add it to the right line in Excel.

So now it's the turn of Pro/E !
I have no experience in programming with Pro/E, but when
I read forums, websites etc...it looks the mess. I get
lost between Pro/Weblink, Pro/E VB API, J-Link,
Pro/Toolkit, the trails files. I can't find any tutorial
on internet about how to start an API with Pro/E.

From your experience, which API can you advice me, and
how can I start it ?
(I know that I can't use Pro/E VB because it starts with
Wildfire 4 and I'm using a previous version)

And no PLM here yet.

Thank you,

Thomas

 

[_TL_]

Hi Thomas,
VB API is most suitable for you, but if you cannot use it, I recommend you Automation Gateway. This library has COM interface you can easily use in Excel and all ProE a Creo versions are supported.
I have used it for several projects. Send me your email and I can send you its documentation if you are interested.

Regards,
Tom

 

[TotoB]

I send you a pm, thank you !


Otherwise, I was starting to think about to see if, when I
save text from the drawing in name.txt.x, it appears on
trail file and after modify it to adapt it, and write a
macro on Excel which will open all the drawing following
this trail file (I don't know if it's possible)

 

[TotoB]

Pm are not working right now I will try later

 

[_TL_]

you can mail me to: tomas.loun [at] centrum.cz

 

[TotoB]

Ok thanks. It's sent !

D

 

[TotoB]

I finally manage to do it (and for free), I will explain
quickly for people in same case as me.

I did it with a macro on Excel wich is writing a trail
file according to name of the files in the disk, and
launch via this macro a batch in no windows mode wich
will run the trail file. The trail file is openning each
drawing and saving in .txt the data I want and after it's
easy to analyse it with the macro in Excel.

Don't hesitate to ask more details if interested in.

Thomas