CATIA macro and Excel connection

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 พ.ย. 2024

ความคิดเห็น • 47

  • @vinayababuyerneni255
    @vinayababuyerneni255 4 ปีที่แล้ว +1

    I was searching for this for a long time, thank you.

    • @haarrun
      @haarrun  4 ปีที่แล้ว

      I'm glad I can help

  • @hilalzeytinci
    @hilalzeytinci ปีที่แล้ว +1

    Thank you for this video!!

  • @othman3275
    @othman3275 2 ปีที่แล้ว

    thanks for this work, does it for intersection point ?

    • @haarrun
      @haarrun  2 ปีที่แล้ว

      Mm, I m not sure.. You can try

  • @marciospingola7849
    @marciospingola7849 4 ปีที่แล้ว +1

    What nice video!!!

  • @maximo19811000
    @maximo19811000 3 ปีที่แล้ว +1

    Well done, how can I import product structure names from Catia to excel and rename it?

    • @haarrun
      @haarrun  3 ปีที่แล้ว

      Hi, you want to export product catia names to excel? And change it in the Excel?

    • @maximo19811000
      @maximo19811000 3 ปีที่แล้ว

      @@haarrun exactly

    • @haarrun
      @haarrun  3 ปีที่แล้ว

      @@maximo19811000 You need for loop or while loop which will go through CATIA tree and export it to the Excel file. You have those kind of Macros on the internet. And after that you can rename it.

    • @haarrun
      @haarrun  3 ปีที่แล้ว

      Also I can write any kind macro for you.

    • @maximo19811000
      @maximo19811000 3 ปีที่แล้ว

      @@haarrun can you send me a string of code please?

  • @abdul-kareem4429
    @abdul-kareem4429 ปีที่แล้ว

    Is this possible for points (i.e., vertices) that are part of sketch?

    • @haarrun
      @haarrun  ปีที่แล้ว +1

      Hello, yes, you just need to loop through the sketch points. I don't know how to loop when there are other elements in the sketch, for ex. Lines and circles, so easiest way is to have only points in the sketch. I forgot how that goes, but something like geometrical elements or something like that.

  • @PestoChampion
    @PestoChampion 4 ปีที่แล้ว +1

    Fascinating to discover this! Thanks for sharing! Please feel free to pop over to our Channel and check out our latest post too!

  • @harisankar8018
    @harisankar8018 ปีที่แล้ว +1

    line 35 column 9
    source- compilation error
    description- excpected end of statement
    statement- Dim oSel as Selection
    how to rectify this error

    • @haarrun
      @haarrun  ปีที่แล้ว

      You need to put end of statment maybe you forgot?

    • @harisankar8018
      @harisankar8018 ปีที่แล้ว

      @@haarrun i put end of statement. still showing same error

    • @harisankar8018
      @harisankar8018 ปีที่แล้ว

      @@haarrun plz help to rectify. urgently require this to complete my project

    • @haarrun
      @haarrun  ปีที่แล้ว

      @@harisankar8018 send me your code on musicharun@hotmail.com

    • @harisankar8018
      @harisankar8018 ปีที่แล้ว

      @@haarrun sent . thank you in advance

  • @vijayacholla
    @vijayacholla 2 ปีที่แล้ว

    Hi is it possible to create macro to get clash number between 2 products and export the values to excel...?
    Could you please help me to creat one...?

    • @haarrun
      @haarrun  2 ปีที่แล้ว

      Hi, yes, I wrote that macro, also it take pictures of the chlases. You can contact me on my mail musicharun@hotmail.com

  • @Arshbunny18
    @Arshbunny18 4 ปีที่แล้ว +1

    Hi, how can i export the part volume, area, and other measurements in excel file directly from Catia?

    • @haarrun
      @haarrun  4 ปีที่แล้ว

      Hello, you can use method from this video with the combination of this video th-cam.com/video/gxyFAwvLsBU/w-d-xo.html You just need to measure it and then export. Its not hard to code it.

    • @Arshbunny18
      @Arshbunny18 4 ปีที่แล้ว

      @@haarrun thanku so much brother. Let me test it. Can i contact you on ur email address? I might need your help in the future.

    • @haarrun
      @haarrun  4 ปีที่แล้ว

      @@Arshbunny18 yes feel free to contact me, you can use contact on my website.

    • @Arshbunny18
      @Arshbunny18 4 ปีที่แล้ว

      @@haarrun Hi Brother, i am unable to contact you using your wesbite's web-form. It is coming up with an error.

    • @haarrun
      @haarrun  4 ปีที่แล้ว

      @@Arshbunny18 musicharun@hotmail.com. here is my mail

  • @anhkhoaluong7364
    @anhkhoaluong7364 4 ปีที่แล้ว

    can you give me a VBA source? plz!
    I appreciate it.

    • @haarrun
      @haarrun  4 ปีที่แล้ว

      Hello, you have link to my website in the description of the video. There is full code to it.

  • @johnwasserplatz167
    @johnwasserplatz167 2 ปีที่แล้ว

    How to export geoset name as well?

    • @haarrun
      @haarrun  2 ปีที่แล้ว

      Hello, the easiest way is to add one more selection for the set and just take the name of the selection, second solution is to use parent of the one point in the selection.

    • @johnwasserplatz167
      @johnwasserplatz167 2 ปีที่แล้ว

      @@haarrun thanks so much, will this work on the geoset parent as well? If I need the name of the geoset the point is under and the name of the geoset the geoset is under? Like if there are geosets within geosets?

    • @haarrun
      @haarrun  2 ปีที่แล้ว

      @@johnwasserplatz167 Hi, yes but it must be same structure, for example you want to go with two geo, it must be two. Or you need to make some if statements if you want to be different. Here is link for the beginning www.eng-tips.com/viewthread.cfm?qid=485048

    • @johnwasserplatz167
      @johnwasserplatz167 2 ปีที่แล้ว

      Ok thank you. So if I add one more selection, can it be a part of the same FOR loop?

    • @haarrun
      @haarrun  2 ปีที่แล้ว

      @@johnwasserplatz167 only if you need it too, for example if you have 10 points in one geo, then you don't need it to be in the for loop. From other side if you have for every point one geo then it need It to be inside for. I think first option is better it that is the case.