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...
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...
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...
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...
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...
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?
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...
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...