Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK 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: *

  • Users: perzentkar
  • Order by date
  1. perzentkar

    Exporting Catia drafting dimensions to excel

    Set xl = CreateObject("Excel.Application") Set Workbooks = xl.Application.Workbooks Set myworkbook = Workbooks.Open("C:\Users\office5\Desktop\Macro template.xlsx") 'ExcelTemplate = diretory/name of Excel Template Set myworksheet = myworkbook.Worksheets.Item("Sheet2") 'Item(x) or Item("name of...
  2. perzentkar

    Exporting Catia drafting dimensions to excel

    Hello Marc, This worked out really well except it doesn't Launch excel upon completion, it doesn't launch that file for me at least. It does export the values into that file properly but it gives me a ghost telling me the file is open when it really isn't. I can open the template manually and I...
  3. perzentkar

    Exporting Catia drafting dimensions to excel

    Good morning Guys, The macro is working perfectly and exports everything as desired automatically. We have elected to just manually enter tap callouts and such. I see that in the macro it opens excel and exports the values to a new document. How would I go about making it export to a specific...
  4. perzentkar

    Exporting Catia drafting dimensions to excel

    Good morning, I would establish a tap callout via text with leader. I don't think I would ever have it attached to a dimension. I would like to be able to select all the dimensions manually, then run the macro. I would like the macro to export the dimensions to excel following the order I...
  5. perzentkar

    Exporting Catia drafting dimensions to excel

    Good morning, Thank you for all the help. This has been a great tool. How do I get it to export the values into excel in the order in which I select them on my drawing? If I wanted it to export a text such as 1/4-20 tap How would I go about doing that? Or is it just better to manually enter...
  6. perzentkar

    Exporting Catia drafting dimensions to excel

    Good afternoon, How would I go about getting this macro to export the values in imperial units verses metric? What Value do I need to change? How do I get it to pull the same number of decimals that are displayed in the drawing?
  7. perzentkar

    Exporting Catia drafting dimensions to excel

    Thank you very much :) This works perfectly for my needs.
  8. perzentkar

    Exporting Catia drafting dimensions to excel

    thank you very much for the help. I'll see if I can combine the two macros in some way and get the associated view to populate.
  9. perzentkar

    Exporting Catia drafting dimensions to excel

    Good morning all, Does anyone have any pointers on how to accomplish what I am asking for? Thanks for the help :)
  10. perzentkar

    Exporting Catia drafting dimensions to excel

    Good morning, I have created a simple part drawing that serves as a good sample part which includes everything I need. I have also included a second excel spread sheet that includes multiple ways of displaying the data. The first group in excel displays the data with the dimensions, balloons...
  11. perzentkar

    Exporting Catia drafting dimensions to excel

    thread560-345707 Good morning all, I'm happy to be a part of the forums. I am new to using macros in Catia, we are using Catia V5 R19. I am trying to write a macro that will export selected Catia dimensions, tolerances, associated views, and their balloons to a .csv file. I have gotten it to...

Part and Inventory Search