Visual LISP, AutoLISP and General Customization
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

call excel macro from lisp

2 REPLIES 2
Reply
Message 1 of 3
vahe.holtian
934 Views, 2 Replies

call excel macro from lisp

hey

 

i want to call an excel macro from a lisp. is it possible?

 

now i have this:

(startapp "C:\\Program Files (x86)\\Microsoft Office\\Office12\\Excel.exe"
    (strcat "\""
     (getvar 'dwgprefix)
     (vl-filename-base (getvar 'dwgname))
     "XXX.xls\""
    )
)

 

 

i just want it to run macro1 from book1.xls

 

is it possible and how?

 

thanks

2 REPLIES 2
Message 2 of 3
vahe.holtian
in reply to: vahe.holtian

anyone?

 

i found another way to do it by vba which is: open excel, send command to autocad then run the macro but it seems slow to me

 

is there a way to open an excel file and run macro1 by lisp?

 

thanks

Message 3 of 3
Hallex
in reply to: vahe.holtian

I think it's impossible,

instead of you could to create a button on Excel book

and add Sub to perform your macro in AutoCAD

_____________________________________
C6309D9E0751D165D0934D0621DFF27919

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost