Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. suleymanyaman

    What does it mean of RotX,RotY,Rotz?

    Calculation of Rotx,y,z in here with code algorthm. Maybe this is useful another one in future. http://www.euclideanspace.com/maths/geometry/rotations/conversions/matrixToEuler/index.htm
  2. suleymanyaman

    Open excel file and overwrite and check

    Yes,exactly you are right.in meanwhile I got CAT Portable Script but I didnot examine deeply. I will look this folder again.
  3. suleymanyaman

    Open excel file and overwrite and check

    First of all in below I created xls files(thanks E.Ross) and save defined path. And also I want to access this file then I want to check "if xls opened or activated" else if not I want to open and I want to overwrite these values "oExcel.cells(6, 5)=sname" sname(1),sname(2).... I want to...
  4. suleymanyaman

    Catia to Excel File by Macro (Failure)

    first of all I am glad your help,thank both of you.It works correctly.And also I have another question if it is ok I will give a link here you are.If it is not problem can you look at this? Thanks a lot. http://www.eng-tips.com/viewthread.cfm?qid=350505
  5. suleymanyaman

    Catia to Excel File by Macro (Failure)

    I understood clearly but I am working on .Catvba is it same?Because I saw your Location: c:\program Files(x86)\Microsoft Office\office14\EXCEL.EXE
  6. suleymanyaman

    Open excel file and overwrite and check

    I try to open and overwrite and also check if it is opened.I mean these 3 step like in below but I am not succesfull.(maybe this is more clear now) If strsearch = sname Then sTemp = sname + " = " + CStr(a(9)) + ", " + CStr(a(10)) + ", " + CStr(a(11)) Dim Mydirectory As String Dim...
  7. suleymanyaman

    Open excel file and overwrite and check

    Hi dear friend or members I have some values and I want to overwrite excel file before I create path in down. However I didnot open created file.Also I want to check this file was opened do something. Thank you for helping. If strsearch = sname Then sTemp = sname + " = " + CStr(a(9)) + ", "...
  8. suleymanyaman

    Catia to Excel File by Macro (Failure)

    I solve this question myself.I guess I am wrong while defined excel documentation."Dim workbooks As Workbooks" is changed "Dim workbooks" then solved it. Thank you.
  9. suleymanyaman

    Catia to Excel File by Macro (Failure)

    Hi Dear Friends, I create a catia macro for "product" and I want to export from catia to excel. However it gives failure in Dim workbooks As workbooks Dim workbook As workbook compile failure is"User-defined type not defined" codes in below.Thank you. Sub MatrixPrint(ByVal sName, ByVal...
  10. suleymanyaman

    What does it mean of RotX,RotY,Rotz?

    Hi Dears, I want to figure out Rot X,RotY,RotZ.As far as I know that these notions represent changing angle between world zero and interface zero. Maybe, this is wrong. Can you help me please? PS.Also my real target,I want to calculate this value by macro.For example, move>position>click...
  11. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    It is OK itsmyjobs I will struggle about this.I am glad your support.I hope overcome that. REGARDS
  12. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    Thank you itsmyjob.I checked v5automation.chm before and until the now I understood that RotX,RotY,RotZ values(it means you know for example:45degrees,0 degrees,90 degrees etc.)I cannot reach by this method.Can you give me any idea for this problem?
  13. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    Actually it is confusing.briefly ı try to explain again sorry about amateur student mavement:( I add new one.I understood calculation matrix and inverse but how can I have myInputPart's X,Y,Z values?I mean my target is which I want to have position values I want to access,so I did not entegrate...
  14. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    Firts of all thank you a lot dear ferdo.I cared your advices appreciately. Altough I have subscirption his blog, the blog still ask me password and I did not receive any password from.Just an email is sent and it said "EMAIL Subscription Confirmed" but I dont still access. Secondly I tried to...
  15. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    Thank you Iam just want to be clear.By this way I shared this explanation.I am glad to help :)
  16. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    For example, I found my part's volume and mass thanks to below codes.And also ı want to figure out position (x,y,z,rotx,roty,rotz) by like these codes.Is it possible?Thanks a lot now. MsgBox "Part Volume: " &MyProduct.Analyze.Volume MsgBox "Part Mass: " &MyProduct.Analyze.Mass...
  17. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    Actually,I want to measure an interface coordinates or position values(X,Y,Z,ROTX,RotY,RotZ) from world zero.
  18. suleymanyaman

    HOW TO GET POSITION AND ROTATION VALUES

    I glanced at this link but in here if I am not wrong,user enter into some values and user sets or changes rotation values.How ever I would like to get values automaticly.I add an image file.And also I want to get this values.I am appraciate for...
  19. suleymanyaman

    How to collect an array part name

    Thank you dear jagandeep.
  20. suleymanyaman

    How to collect an array part name

    Maybe you can think about greedy please not,but how can I use this part information to reach position ,translation ,rotation values about interfaces?If you are busy you can give just one sample for example just rotation and I can research other topic.Otherwise I can produce idea logicly about...

Part and Inventory Search