If you are in Acad you can access an excel file with vlisp. This seems to be what you are trying to accomplish. I thought I've seen different examples through out this forum of people accessing excel tables.
Now if you are trying to just use excel and write a macro within it without anything from autocad coming into play, I'd suggest just using vba.
Dear Greg and Maverick®,
With visuallisp you can make a file in Excel
HOFCADLT.XLS and users can change that Excel file, it would be nice that they can activate AutoCAD for an update with an Excel macrobutton.
Then you have a two way of communication (bidirectional).
Specific example :
1)VisualLisp is writing a spreadsheet for development of a cone.
2)Users make there choice in diameters and height in that spreadsheet.
3)Then they click on the macrobutton 'Update' and then they get the development in AutoCAD.
Another advantage is: That when you write the macro with VisualLisp, Lisp
can decide for
ChannelNr = Application.DDEInitiate("AutoCAD.r16.dde", "System") or
ChannelNr = Application.DDEInitiate("AutoCAD.r17.dde", "System"), which is
necessary for working in AutoCAD 2006 or AutoCAD 2007
I think
: "If it is possible in VBA, then it is also possible in VisualLisp", because I saw the writing of an hyperlink with VisualLips into Excel
(Saving an hyperlink to an Excel cell from Patrick_35).
There for the question is still:
Is it possible to make a macro and a macrobutton in Excel with VisualLisp?Regards,
HofCAD CSI.
PS1Change the green values in
HOFCADLT.XLS and use the yellow macrobutton Update, and look to the result in AutoCAD.
PS2May be you have to change at the top of the macro's:
Const ver As Integer = 16
Const arr As String = "-ARRAY"
PS3Sorry for my English.