Page 1 of 1

TC does not honor "/x" parameter when opening Excel file when dropping file on panel button

Posted: 2020-08-29, 12:53 UTC
by Sektor
I have a button on panel which calls Excel 2016 with "/x" argument. This argument makes Excel run in separate process, so that other Excel workbooks won't "see" my new book. Here's my button.
What I do: I drag Excel file onto this button.
After that Excel fires up and opens my file. But it's not in separated process. One could argue that I can't verify it since beginning from Office 2013+ there is one EXE process for each file and thus I can't understand that file is in another process since I will see TWO "EXCEL.EXE" processes. But there's a way to tell that one file doesn't see another: you just need to copy some range in one book, go to that newly opened workbook and call out right-click menu there. If there are 3 buttons - then workbook is in another process. Otherwise, if there are 6 buttons - files are in one process.

Re: TC does not honor "/x" parameter when opening Excel file when dropping file on panel button

Posted: 2020-08-29, 13:31 UTC
by Dalai
When dragging anything onto a button, the button launches its command with the dragged file as single parameter. Any parameters defined in the button are ignored. That's the way it's always been in TC.

To solve this: Add %P%N to the button's parameters, set the cursor on the file and press the button. No dragging required.

Regards
Dalai

Re: TC does not honor "/x" parameter when opening Excel file when dropping file on panel button

Posted: 2020-08-29, 15:34 UTC
by Sektor
Thanks for reply. It's a pity that it doesn't work this way.

Re: TC does not honor "/x" parameter when opening Excel file when dropping file on panel button

Posted: 2020-08-29, 19:15 UTC
by HolgerK
Sektor wrote: 2020-08-29, 12:53 UTC I have a button on panel which calls Excel 2016 with "/x" argument. This argument makes Excel run in separate process, so that other Excel workbooks won't "see" my new book. Here's my button.
What I do: I drag Excel file onto this button.
...
Try placing the parameter "/x" directly in the command line: "<ProgramPath>\EXCEL.EXE /x".

HTH
Holger

Re: TC does not honor "/x" parameter when opening Excel file when dropping file on panel button

Posted: 2020-08-29, 20:09 UTC
by Sektor
@*HolgerK
Oh, thanks a lot - that works! 😉 I completely forgot about this way. 🤩