CAD tip # 9320:

Question

CAD

% platform category

Export of Inventor 3D sketch coordinates to Excel.

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

*CAD

27.6.2013 29731×

Comments Tell a friend

applies to: Inventor 2014 · Inventor 2013 ·

See also:
Tip 14547:	How to generate 3D PDF files from Revit?
Tip 14367:	What CAD formats are supported in the free Personal (hobby) license of Autodesk Fusion?
Tip 14335:	Convert TrueType text in an Inventor sketch to a contour curve.
Tip 14240:	How to simplify an uneven profile imported via DXF into Autodesk Fusion?
Tip 13719:	How to load a 2D DWG drawing of a part into Fusion 360?

Selected tip: How to re-enable a disabled Auto Stacked fractions MText dialog in LT?

Back All CAD Tips

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:

Text:

FAQ

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

Please use these tips at your own risk.
ARKANCE is not responsible for possible problems that may occur as a result of using any of these tips.

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.

ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111



Visitors now: 3815