Run Macro in Excel from Autocad

[Breizh29]

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..."

Please Login or Register  to view this content.

Thanks for your help.

[Marcol]

Hi Breizh29

You have enclosed your code in Quote Tags not Code tags, if you correct this then I will have a look, your code appears to be cut short.

I wrote the Excel/AutoCad macro

Cheers
Alistair

[Breizh29]

Thanks Alistair,
yes this is a part of your code.
As i have many code lines below i did not want to overload the page.
I tried this afternoon in running the macro direct from Excel, it works without problem.
Then when i execute from ACAD with the code above, it seems to launch it on excel, but then Excel freeze.
I think the macro in ACAD runs the macro from excel from the first WS ( where it shoudl be run), but then try to access "Sheet1" in the same time, where the data ( result of the macro) resides.
I may have to enter a code that waits for the end of the macro, before it can continue its code in ACAD ?
Thanks for your help.

[Marcol]

Hi Breizh

Thanks for changing your post.

It doesn't show the whole Sub. Does it show all your changes?

It would be better with a sample file showing me what "Schedule4Trays.xlsm!ODCheck" does, I can guess by the sheetname, but guessing is never a good thing. Are the tray sizes in the same workbook?

Then I can set it up to try the whole exercise.

Is that possible?

I'm a bit rusty with AutoCAD Vba so it might take a few days to get you a result, unless , of course, someone else has a go.

Cheers
Alistair

[Breizh29]

Hi,
here below the main part of code , which will be maybe more helpful to locate where is the problem .
I did copy only the first half part.
The macro i want to execute : ODCheck, has to be run with the " SEA_DRAGON_CABLE_SCH" WS activated.
Then it extracts some data to copy them in Sheet1!.
ACAD then uses these data from Sheet1! to generate its drawing.
Hope its more clear.

Please Login or Register  to view this content.