Hi all,
i have almost completed my project, but i am facing a problem.
I have a VBA program ( in ACAD), that opens a workbook and retrieve the data to generate drawings , based on excel cells values; this works perfectly.
Now , i want my ACAD program to load this same WB in excel, then execute a macro (based in the excel WB), then when complete continue to run the program in ACAD.
Before the first Excel macro is executed, it needs to get a value from ACAD user form input box, then use it for its macro ( Excel).
So my the question is in the title : how i can run the macro in excel from ACAD ?
i cannot figure out the code associated to this. Hope it is clear.
This is the code i try to run the macro:
it opens the excel sheet, but then excel freeze as soon as it passes the line "run..."
Thanks for your help.
Bookmarks