Excel Problem

[Anonymous]

I have a VBA macro in 2000i that opens Excel, saves and closes but it is
trying to close Excel before its done saving. What would be the best way to
make it wait until its done?

[Anonymous]

i have not yet utilized it, but i think DoEvents might work. It pauses the
program to let operations finish.

"Chris W" wrote in message
news:7123DC2FE220E4414C699D37D200C065@in.WebX.maYIadrTaRb...
> I have a VBA macro in 2000i that opens Excel, saves and closes but it is
> trying to close Excel before its done saving. What would be the best way
to
> make it wait until its done?
>
>

[Anonymous]

write the "save and close" macro in excel.
then get autocad to run that macro
along the lines of
objXL.run("macroname")
"Chris W" wrote in message
news:7123DC2FE220E4414C699D37D200C065@in.WebX.maYIadrTaRb...
> I have a VBA macro in 2000i that opens Excel, saves and closes but it is
> trying to close Excel before its done saving. What would be the best way
to
> make it wait until its done?
>
>