XL.lsp ReadMe.txt file:                Version 3.1     5/8/05

  Requires AutoCAD R2000+, Excel 8.0+

  Please place all files inside the XL.zip file in your autoCAD search path.

  The files are:

  XL.lsp               Version 3.1  Dated 5/8/2005  Size: 8  kb
  XL.dcl               Version 3.1  Dated 5/8/2005  Size: 2  kb
  XL_Chart.lsp         Version 3.1  Dated 5/8/2005  Size: 12 kb
  XL_PutTxt.lsp        Version 3.1  Dated 5/8/2005  Size: 5  kb
  XL_PutAtt.lsp        Version 3.1  Dated 5/8/2005  Size: 6  kb
  Xl_Get.lsp           Version 3.1  Dated 5/8/2005  Size: 15 kb
  XL_Get.dcl           Version 3.1  Dated 5/8/2005  Size: 1  kb
  XL_ReadMe.txt        Version 3.1  Dated 5/8/2005  Size: 7  kb
  XL_Test.xls                       Dated 5/8/2005  Size: 14 kb

                            Total after extraction: Size: 70 kb     



  Instructions:


  To load the program:

  (load "XL")<enter>

  To run the program

  XL<enter>

  Select your options...

  Replace Text Option :

    If the program finds a text entity with a value of one of the cells
    found in the spreadsheet, (Examples: "A1" "AB1" "B45") it will change the
    value of that text entity to the value found in that spreadsheet cell.

  Replace Attribute Option :

    If the program finds an attribute tag with a value of one of the cells
    found in the spreadsheet, (Examples: "A1" "AB1" "B45") it will change the
    value of that attribute to the value found in that spreadsheet cell.

  Draw Chart Option :

    This will draw a simple chart using the data found in the Excel file.
    Simple charts only.  I'm not in the chart drawing competition with
    Bill Gates.

  Select the Excel file you want to get the data from.

  Select the Sheet inside the Excel file to get your data from.

  -----------------------------------------------------------------------------------

  Help

  If you get the "Excel Object Library not found" message:
   
     1.  Download the latest version from http://www.jefferypsanders.com and
         try it again.  If the message still appears go to step 2.

     2.  The reason the program cannot find your Excel Object Library could
         be one of two reasons.  

         First reason:
         The first reason could be, you are using an Excel version
         that is not Excel 8.0 through Excel 2003.  If the version you are 
         using is older than 8.0, your just out of luck.  

         Second reason:
         XL_GET.lsp searches your hard drive for the Excel Object Libarary
         in the default install directories.  If you have installed Excel
         in any other directory, XL_GET will not find it.  Also, if your 
         version of Excel is older than Excel 8.0 or newer than Excel 2003,
         XL_GET.lsp will probably not find the object library.  So....

         If Excel is newer than 2003 or Excel is between version 8 and 2003,
         and your getting the "Excel Object Library was not found" error:

           Search your hard-drive for the library.
             It will either be:
             A file that starts with "XL" or "EXCEL" and has an entension of ".OLB".
             Or 
             It will be the actual "Excel*.exe" file.  
 
             Search for the ".OLB" first. If you find it, continue below.  If you
             do not find the OLB file, search for the Excel*.exe file.  If you find
             the path, continue below.

             If you find the path to the "Excel Object Library", open the XL_GET.lsp
             program and add it to the list of directories to search.  The area in
             the XL_GET.lsp program looks like this:

              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel8.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel9.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel10.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel.exe")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office10\\Excel.exe")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office11\\Excel.exe"))) 
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office11\\XL5EN32.OLB")))
             
              Copy and paste the closest match above and only edit the text inside the quotes.  The 
              sysDrive variable contains the drive letter to the area where your windows system files
              are located and most likely the same place Excel was installed.  If Excel is on a different
              drive, and only if Excel is on a different drive, replace the entire string to reflect the
              path.  It would something like this:

              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel8.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel9.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel10.olb")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office\\Excel.exe")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office10\\Excel.exe")))
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office11\\Excel.exe"))) 
              ((findfile (strcat sysDrive "\\Program Files\\Microsoft Office\\Office11\\XL5EN32.OLB")))
              ((findfile "D:\\Program Files\\Microsoft Office\\Office11\\Excel.exe"))  ;<--This is the new line!

              *NOTE* - Watch the parenthesis closely.  Notice there are only two left and right parenthesis!

              If this does not solve the problem, email jps@jefferypsanders.com with the error message, the
              version of AutoCAD, the version of Excel, and the version of your operating system.

              END OF OBJECT LIBRARY HELP




  If you receive the error message "Exit/Quit/Abort": 

    This usually means the DCL files are not located inside the AutoCAD search path.

    Move the DCL files inside the AutoCAD search path and try it again.

    If you need help with this, check the help file on my web site:
    http://www.jefferypsanders.com/autolisp_XL_Help.html





  More instructions and help for each individual function can be found inside
  the LISP programs.
    
  If you have any problems with the program or suggestions please email:

  jps@JefferyPSanders.com

