Does running the macro via the excel command, leaves the file open while running the macro?
I have file X that contains data and the macro. So when I run the macro, I assume it opens the file and runs the macro, then I want to copy data from X to Y file, so that same macro file to other files.
So can I just run the macro and then only use in the macro arguments a Activation call? Or I still need to open this file via the macro arguments call and then add also the activate? Thank you very much.