Set Excel = GetObject(, 'Excel.Application') 'if Excel is already running, then get the Excel object The first step to exporting any information from inside CATIA is to be able to launch or open Excel.

Export to Excel is highly useful as you can create custom bills of material (BOMs) or part lists at the click of a button.

One of the biggest reasons for learning CATIA macro programming is to be able to automatically export properties from CATIA to an Excel spreadsheet. OSelection.Search 'Name=' & geoName & '*,all' GeoName = Inputbox('Please enter EXACT name of geometry to search for.') Msgbox 'The Selected element's type is ' & oSelEl.Typeĭo you have an enormous specification tree with thousands of pieces of geometry? Do you need to find one specific element within the tree? Rid yourself hours of endless scrolling by searching for those components directly by name. Msgbox ' The selected element's name is ' &

MsgBox 'Number of objects selected: ' & oSel.Count For example, you can find out if a plane is HybridShapePlaneExplicit or HybridShapePlaneNormal. The purpose of this program is to help you figure out the syntax for pieces of geometry. This macro returns the name and type of all objects selected before the program is run. Never created or ran a macro in CATIA before? Want to learn how to create your own custom CATIA macros? VB Scripting for CATIA V5 is the ultimate quick start guide on how you can begin saving yourself tons of time and complete your projects faster. Assign an icon (or create your own) for each macro CATIA macros window keyboard shortcut: Alt+F8ģ. Once a CATScript macro is created, there are multiple ways to open the macros window to run the code:Ģ. Copy and paste the code into the CATScript editor. Go to Tools>Macro>Macros (or hit Alt+F8) to open the macro window.ģ. Feel free to use these in any way that will benefit you.ġ. You can increase your programming speed by reusing snippets of code youve already written that you know work. While each piece of code by itself may not be the final solution to your problem, they can quickly and easily be placed into larger, more complicated programs. The following programs are the snippets of code I find myself using more than any others.

Catia v5 macros