Code Red > AutoLISP (Vanilla / Visual)

"Draw Excel Lisp" Question

<< < (2/3) > >>

terrycadd:
I tried several things during lunch, but couldn't get it to crash. I will take another look at it after work.  It was initially written in AutoCAD R14, and since then has been run daily in engineering on versions 2000i, 2004, 2005 and 2006.  None of the AutoCAD stations required any VBA customizing.  I'm at a loss at this point regarding making any recommendations.  I’ve attached the information from the top menu [Tools / References] screen.

CAB:
I checked mine but made no difference.

terrycadd:
I really hate that you're having trouble with this one, because it's a neat function.
Do you have an option in the VBA Tools/References screen for "Microsoft Excel 11.0 Object Library"?
I noticed the on the lower section that your screen displays ".../EXCEL9.OLB" instead of ".../Excel.exe".
Could this be part of it?

terrycadd:
I was able to find an archive copy of DrawExcel.dvb complied on 2000i just before I made some changes on 2005 regarding replacing commas in a cell to the ascii chr 184. The reason for this revision was that a comma in a cell caused the rows to shift a column over every time it encountered a comma. The routine reads in the C:\Temp\Temp.csv file and then replaces the ascii chr 184 with a comma fixing that problem. I suspect that the VBA “replace” function may not have been included in the VBA utilities with 2000i. But I can’t verify that at this point.
I know that DrawExcel works on other systems as well as ours, as I have received several complimentary emails from around the world. Regarding the dilemma of the possible comma within an Excel cell, I should have probably made a revised version of the “CommaList” function to handle input from csv files.
Since I can’t revert back to 2000i and recompile the dvb file, try downloading the following DrawExcel-2000.dvb file. You may either revise the sub-function “GetExcel” to load DrawExcel-2000.dvb, or you may delete the DrawExcel.dvb file and then rename DrawExcel-2000.dvb to DrawExcel.dvb.
http://web2.airmail.net/terrycad/LISP/DrawExcel-2000.dvb

CAB:
Thanks Terry, I'll give it a try tomorrow. It's past my bedtime here. :-)

I do believe the error has to do with the inability to establish the wbkObj var
as Workbook is highlighted when the error is displayed.
 
--- Code: --- Dim ExcelApp As Excel.Application, wbkObj As Workbook, shtObj As Worksheet
--- End code ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page