Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

macro catia excel

macro catia excel

macro catia excel


Je travaille avec CATIA V5 dont les coordonnées des points dépendent d´une feuille excel.

Voici ce que sais faire:

Je crée 10 points dans Catia dont les coordonnées sont insérées dans la feuille Excel. Ces 10 points sont reliés par une polyligne dont on peut piloter le rayon á chaque point grace aussi á la feuille Excel.

Quand j´ai dix points, tout marche trés bien.

Voici ce que j´aimerais faire:

Prenons le cas oú je n´ai besoin que de 4 points dans ma construction. Je voudrais insérer une macro qui me permettrait d´effacer dans CATIA les 6 points dont je n´ai pas besoin et d´obtenir alors une polyligne qui automatiquement marche et ne relie que les 4 points dont j´ai besoin.

Dans ce cas, dans mon tableau Excel, les coordonnées de tous les points ainsi que les rayons de la polyligne dont je n´ai pas besoin sont á zéro. J´imagine que dans la macro, il faudrait alors faire figurer:

Quand les 3 coordonnées d´un point (hormis le 1er point) sont nulles, effacer ce point dans Catia (aussi bien dans l´arbre de construction que dans la polyligne).

Je ne m´y connais pas du tout en language VB, c´est pour ca que je sollicite votre aide!

Merci d´avance!

RE: macro catia excel

This is an English-speaking site... please repost your question in English, even if you have to use a translation service.

Dan - Owner

RE: macro catia excel


I work with CATIA V5 whose points coordinates are dependant on a sheet Excel.

Here is what I can do:

I create 10 points in Catia whose coordinates are inserted into the sheet Excel. These 10 points are connected by a polyline and we can pilot the beam of the polyline in each point thanks to the sheet Excel.

When I have ten points, everything works very well.

Here is what I would like to do:

Let us take the case where there are only 4 points in my construction. I would like to insert a macro which would allow me to erase in CATIA 6 points from which I do not need and to obtain then a polyline which automatically works and connects only the 4 points which I need.

In that case, in my Excel table, all the points´ coordinates as well as the beams of the polyline which I do not need are zeros. I imagine that in the macro, it would then be necessary to write:

When all the 3 coordinates of a point (except the 1st point) are zero, then erase this point in Catia (in the construction tree and in the polyline).

I can´t use the VB langage so I need your help!



RE: macro catia excel

This site has a CATIA forum... you'll probably have better luck re-posting in there and red flag this post for removal...

Dan - Owner

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close