FAQ

This page answers Frequently Asked Questions...

Let's start with a joke:

1. Why does the chicken cross the road?
   To boltly go where no chicken has gone before!
   - or -
   To buy MS-Chicken 2007...
   
   
2. I'am installing on Vista and getting the following error message:
   DllRegisterServer failed with error code 0x80004005
   Try registering the scriptsheets.dll with an elevated command prompt. (Start, All Programs, Accessories, right-click Command Prompt, and then click Run as Administrator) Then use regsvr32.exe
   
   
3. I use Office 2007 where did "Write Autocad Script" go?
   In Excel 2007 the command "Write Autocad Script" is under the add-ins tab.
   
   
4. Can I use the Scriptsheets Add-In in Office 97?
   No you can't the Add-In needs MS-Excel 2000, XP, 2003 or 2007
   
   
5. I'am getting the following error message:
   LoadLibrary("...") failed.
   GetLastError returns 0x0000007e
   You have obmitted double quotes or you have made a spelling mistake in the path to the Scriptsheets.dll.
   Correct syntax look something like this:
   
   Regsvr32.exe "c:/Program files/Scriptsheets/Scriptsheets.dll"
   
   
6. #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.
   
   
7. 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
   close
   new .
   _circle 20,20 15
   expert 2
   save circle.dwg
   close
   open mydrawing.dwg
   _insert circle=circle.dwg 0,0 1 1 0
   
   
8. 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 writen 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
   
   
9. Is it possible use a VBA macro to write a scriptfile?
   Yes you can invoke the writescript method of the Scriptsheet object; 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 Scriptsheets.dll

   • Paste the following macro into a module

     Sub WriteAutoCADScript()
        Dim objectvar As Scriptsheets.AddIn
        'Create a new instance of the class
        '
        Set objectvar = New Scriptsheets.AddIn
        'Run writescript method
        '
        objectvar.Writescript
     End Sub

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