Questions and answers

  1. What version of Excel do I need?
    You can install the Scriptsheets.xlam add-in with Microsoft Excel 2007 and newer.
  2. Can I use the Scriptsheets Add-In in a 64bit version of Office?
    Yes .xlam add-ins can be loaded in 32bits and 64bit Office version.
  3. #NAME? values show up in my sheet and scriptfile?
    Each scriptsheet workbook contains additional worksheet functions which are implemented as VBA macro’s.
    MS Excel uses security levels for macro virus protection. If the security level is set to high then macros are automaticlly disabled when a workbook is opened!
    Instead of the result of a perticular function cells which will show #NAME? you should change the security level for macro virus protection to medium.
  4. How do I make a block using a script file?
    Using a script file to select the objects that you created is the problem. However when you first open an empty drawing and than draw you block-entities, save the file and close it, you can later insert the file as a block.

    expert 2
    save mydrawing.dwg
    new .
    _circle 20,20 15
    expert 2
    save circle.dwg
    open mydrawing.dwg
    _insert circle=circle.dwg 0,0 1 1 0

  5. DTEXT command brings script to a halt?
    Using DTEXT in a script has problems and is a known AutoCAD defect logged against DID 107799 – DTEXT IS NOT SCRIPT COMPATIBLE. You can always use TEXT instead as shown in the sample script below. The blank lines are written to a script file when you use a semicolon “;” in the scriptsheet.

    _text _justify _mc 0,0 2.5 0
    First dtext line
    <blank line>
    <blank line>
    Second dtext line

  6. Is it possible use a VBA macro to write a scriptfile?
    Yes you can invoke the writescript method of the Scriptsheet VBA project; following these steps:

    • In MS-Excel press Alt+F11 to start VBA environment
    • In the Tools menu choose References
    • Click the Browse button and add a reference the ScriptsheetsVBAProject
    • Paste the following macro into a module

      Sub WriteAutoCADScript()
      ‘Run writescript method

      End Sub

    • Select worksheet containing the script program and run the WriteAutoCADScript macro to write a script.