How to adjust settings for Microsoft Visual Basic for Application to run Excel files with Macros for NanoCAD Free/AutoCAD

For NanoCAD Free/AutoCAD automation and Excel files with Macro running please adjust settings for Microsoft Visual Basic for Application please do these steps:

NanoCAD Free users:

1. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:
“nanoCAD Type Library (NCAuto.dll)”
“OdaX Type Library (OdaX_csd.dll)”,
then press OK.


2. Close Microsoft Visual Basic for Application editor.
3. Enable Macros in Excel
https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12

If you need to download and install NanoCAD Free, please follow these steps:
1. Download NanoCAD Free
http://nanocad.com/page/DownloadNanoCAD
2. Read official NanoCAD installation guide
http://nanocad.com/page/InstallationGuide
In PDF format
http://nanocad.com/images/InstallGuide/InstallGuide.pdf
Use video guide
http://nanocad.com/page/InstallationVideo
3. Don’t forget to register and activate NanoCAD Free.

AutoCAD users:
1. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:
“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),
where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);
“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);
“AXDBLib” (axdbXXenu.tlb),
then press OK.




2. Close Microsoft Visual Basic for Application editor.
3. Enable Macros in Excel
https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12

3 comments:

  1. You could do an extraction of dynamic block attributes

    ReplyDelete
  2. I've been using CADHOBBY IntelliCAD for my personal projects for a few months now, and I can say that it's one of the best CAD software for hobbyists. It's user-friendly, and the learning curve is not steep.

    https://www.cadhobby.com/

    ReplyDelete

Please send your comments and suggestions: