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

Please report only one bug per message!

Moderators: white, Hacker, petermad, Stefan2

Post Reply
Sektor
Member
Member
Posts: 157
Joined: 2007-04-04, 10:11 UTC
Location: Russia

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

Post 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.
License #299429
There is no knowledge that is not power
User avatar
Dalai
Power Member
Power Member
Posts: 9388
Joined: 2005-01-28, 22:17 UTC
Location: Meiningen (Südthüringen)

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

Post 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
#101164 Personal licence
Ryzen 5 2600, 16 GiB RAM, ASUS Prime X370-A, Win7 x64

Plugins: Services2, Startups, CertificateInfo, SignatureInfo, LineBreakInfo - Download-Mirror
Sektor
Member
Member
Posts: 157
Joined: 2007-04-04, 10:11 UTC
Location: Russia

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

Post by *Sektor »

Thanks for reply. It's a pity that it doesn't work this way.
License #299429
There is no knowledge that is not power
User avatar
HolgerK
Power Member
Power Member
Posts: 5406
Joined: 2006-01-26, 22:15 UTC
Location: Europe, Aachen

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

Post 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
Make our planet great again
Sektor
Member
Member
Posts: 157
Joined: 2007-04-04, 10:11 UTC
Location: Russia

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

Post by *Sektor »

@*HolgerK
Oh, thanks a lot - that works! 😉 I completely forgot about this way. 🤩
License #299429
There is no knowledge that is not power
Post Reply