Excel Draw v5 and v6 Training Part 7 - VBA Automation with Excel Draw - Create CAD Drawings with VBA

In this video we cover the VBA Automation Features Excel Draw v5 and v6. This video covers the basics and how you can use this to create, view, graph and effect Excel Draw through custom VBA.

Excel Draw by Gray Technical lets you open, read, view, share and create CAD drawings inside Excel using DXF files or making your own with raw XYZ Data!

00:34 - Excel Draw API
02:26 - Installing Excel Draw API into a Macro Workbook
03:03 - Documentation on API
03:31 - How to create an object through VBA

( GTED_CREATE_OBJECT [OBJECT], [RANGE], [Z Y/N], [RELEVANT Y/N], [LAYER#] )

05:19 - Generate Graph Code
( GTED_Generate_Graph )

05:42 - How to use the code
08:40 - Example with linking code to buttons

#ExcelDraw #Excel #GrayTechnical

[chairjacker]

How about an s pen feature which allows you draw actual areas which come out as values in the x, y columns. If possible it would be a really cool feature. I know that the floor plan creator app has this and exports the values to excel. Not just for me, but it would automate the typing of values.

[johnlindskog]

Please add an optional argument to turn off grid and axes and auto-zoom the window.

[june-junesantos]

Since the range uses “A1:E1” for example, how about using a loop like Do until? For example I want to draw series of rectangles using 1 button.