How to use Microsoft Excel using Visual LISP

[Kailas Dhage]

Hi !

AutoCAD automation related function are implemented in Visual LISP,
But How do I use other Automation enabled applications, such as MS Excel,
MS Word through Visual Lisp.

Manual says following.
Retrieves the top level AutoCAD application object for the current AutoCAD
session
(VLISP Function)

(vlax-get-acad-object)

Example:

_$ (setq aa (vlax-get-acad-object))

#<VLA-OBJECT IAcadApplication 00b3b91c>

What about other automation enabled applications.

Please Help Me.

Email: kai...@uts.com

Thanks.

Kailas Dhage

[Tony Tanzillo]

Visual LISP can get pointers to Automaton objects, but
using ActiveX automation in Visual LISP (including vla-
methods with AutoCAD) is generally not possible in a
practicle sense, because an exception will cause the
Visual LISP application to abort.

You can use the vla-GetInterfaceObject method to get an
Automation object, but you're going to find that you're
wasting your time.

--
/*********************************************************/
/* Tony Tanzillo Design Automation Consulting */
/* Programming & Customization for AutoCAD & Compatibles */
/* ----------------------------------------------------- */
/* tony.t...@worldnet.att.net */
/* http://ourworld.compuserve.com/homepages/tonyt */
/*********************************************************/