I am trying to input some variables into an Excel document and whenever I have the Excel document open I am of course able to execute the command. When I have that Excel document open however, I am unable to execute the command because it is being used by another process. I know this is a common issue and I am familiar but I was just wondering if there was ANY WAY possible in Powershell for you to bypass this and still be able to run the command despite having the file (in Excel) open. It allows for convenience sake to make sure the command is running correctly since I can see what is inputting instantly without having to open and close the file every time.
Asked
Active
Viewed 47 times
0
-
1Take a look [here](https://stackoverflow.com/a/17681212/3245749) and see if that helps. They describe a method to connect to an existing instance of Excel, which you could use if the file is already open. – TheMadTechnician Feb 17 '22 at 22:08