I'm working with vba now, but it's a language I had little contact with at the undergraduate level, I'd like to ask some questions.
When a macro in an excel file calls another excel file that also has macro that was closed there is no error, but you try to run a macro with another open error,
Excel file "A" runs and calls "B", terminates the execution as expected until the end of the process, however when running "A" leaving "B" or any other macro open (even if not running) an error occurs.
Another question I have is with DisplayAlerts , it defaults to true and when false does not display messages, responding in a standard way to those that need to answer, but how do I call this method inside excel vba?
I've already tried to use Application.DisplayAlerts = False , I already tried to get the object I'm working with and put "obj".DisplayAlerts = False , but alerts keeps running, how do I solve this?