open/close ba with com

[alrodopial]

Is it possible to close a running ba from excel using com?
if more than one ba instance exists?

open instances?

[negapo]

Hi alrodopial

You want to close the communication between Excel/VBA and BA or you want to actually close BA (shut the program) from code.
The COM is a library that exposes Subs/Functions etc. from the program, i doubt that Gary exposed the Close routine but even if he didn't it's fairly simple to close a program (or all instances) from VBA. You would loop all the programs that are open looking for the name of BA and then when found you would close it with a shell command. I can show you some examples if that helps.

PS: everything is running on my side now.

[alrodopial]

Just started searching how to automate opening ba/linking to excel and closing ba/saving excel files
Best done at specific times of day
Another way is let ba/excel always open, update their lists/selections by vba and auto save any excel files
The second one looks easier to me
I will let you know if I need any further help/ideas
So everything is ok?