Is there a way to run a Macro/ VBA code without using Excel Application Scope. It is always my preference to do data manipulations without opening Excel as much as possible. I have been burned on Microsoft updates when relying on opening the application on a VM. The popups letting you know there something new or something has changed to the application that affects the bot process.
So my original question is there a way to do some sort of Read Range into a variable and performing some Macro on the data without opening Excel?
Thanks