Python Forum

I wasn't sure whether to post this in "General Coding Help" or "GUI", as I'm encountering the problem in a tkinter-based GUI script, but I think the issue is my limited understanding of subprocess.run(), so I thought I'd post here.

What I've written is a script that creates, populates, and saves a spreadsheet, then launches libreoffice Calc and loads the saved file, using subprocess.run(). What I want is for the python script when executed to finish and exit, closing the GUI and leaving the spreadsheet running - in essence, I'd like the script to "launch the desired program and then quit." What's happening instead the spreadsheet launches and loads its data file just fine, but the python script continues running until you close the spreadsheet. I'm wondering whether I need some additional argument to subprocess.run() to fork off a new process in which to run the spreadsheet, or something of that sort.

I've posted only the code that launches the spreadsheet, loads the saved file, and exits, for the sake of brevity.

Any idea what I'm missing.

root = Tk()
# (code omitted for brevity)
# The result have already been written into an .xlsx file, the name of which is stored in saveFileName
run_argList = ["C:\\Program Files\\LibreOffice 5\\program\\scalc.exe",saveFileName]
x = subprocess.run(run_argList)
root.quit()

As described, you can't, because when a process exits, all its child processes are killed.

So the trick is therefore to have the new process started by the desktop process, which remains up until the user logs off. IIRC in Windows this is what the START command does, so you would use, if start is a distinct executable:

run_argList = ["start","C:\\Program Files\\LibreOffice 5\\program\\scalc.exe",saveFileName]

or if start is a built-in command to cmd.exe

run_argList = ["cmd.exe","/c" "start","C:\\Program Files\\LibreOffice 5\\program\\scalc.exe",saveFileName]

in which cas you can likely simplify this to:

run_argList = ["cmd","/c" "start","scalc",saveFileName]

and let cmd.exe figure out what/where scalc is.

Btw, you can divide by two the wear of your backslash key in several ways:

use a "raw" string specification by prefixing the string with r
```
r"C:\Program Files\LibreOffice 5\program\scalc.exe"
```
use a "raw" string specification by using triple quotes
```
'''C:\Program Files\LibreOffice 5\program\scalc.exe'''
```
learning that Windows is perfectly happy with forward slashes(only the CMD.EXE argument parser doesn't like them)
```
'C:/Program Files/LibreOffice 5/program/scalc.exe'
```
(of course if you use cmd.exe in the call above you can't use that form, but you normally don't need the path).

mmwatson

Ofnuts