CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 3324 
Become a fan of CADforum on Facebook Follow us on Twitter
Budweiser blog YouTube channel
Web server of the CAD Studio company (formerly: Xanadu)

CAD tip CAD tip # 9320:

Question CAD 
 %  platform  category 
Q - question

Export of Inventor 3D sketch coordinates to Excel.
A - answer With the Inventor VBA macro Export3Dsketch you can easily export endpoint coordinates of line segments of the selected 3D sketch. The resulting file with XYZ coordinates (CSV) can be opened in Excel or in other spreadsheet application.

You can download the IVB file Export3Dsketch from www.cadstudio.cz/download. Load it into Inventor as a project in the VBA Editor. Then run the macro with the keyboard shortcut Alt+F8. You can choose between relative (sketch origin recalculated to 0,0,0) and absolute coordinates. The exported CSV file is named after the original IPT or IAM file and it is saved to the same folder.

The individual steps are illustrated in a video which can be found in the CAD Video section - see:

Inventor video #82

Export/generate 3D sketch coords

or on the CAD Studio's YouTube channel:

Inv2014Inv2013
100% *  CAD 
27.6.2013    12184×  
Comments   Tell a friend
Prices - CAD eShop:
Koupit Inventor
Koupit Product Design Collection
applies to: Inventor 2014 · Inventor 2013 ·

See also:
Tip 12416:How to export DXF outline of unfolded sheetmetal in Fusion 360, with no bending lines.
Tip 10167:Keyboard shortcuts in Autodesk Fusion 360.
Tip 9528:Using Autodesk Fusion 360 as a CAD converter.
Tip 8991:How to convert a DWG drawing to SVG?
Tip 8024:How to convert 3D models from SketchUp to AutoCAD?
Selected tip: MDT can not find Excel 2000 Deutsch (German)version.


Back   All CAD Tips All CAD tips&tricks

How to remove all anonymous groups from an AutoCAD drawing? « | » Material list on isometric drawings not printed black-and-white.


Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Export 3D VRML scenes from AutoCAD and Inventor
VRMLout More info


Please use these tips at your own risk.
CAD Studio is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist
CAD Forum - tips, tricks, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, 3ds max and other Autodesk software (support by CAD Studio)
Copyright ©2020, CAD Studio s.r.o. - Autodesk PLATINUM Partner & Training Center & Consulting Services Partner
CAD Tips and Tricks • Cesky • Contact webmaster@cadstudio.cz • Advertise with us • CADstudio online privacy