Python - how to open excel sheets at a particular time each day -
in job run 10 or reports day , have bad habit of forgetting them until few minutes before deadline. want make python program run in background automatically open particular excel program when need start looking @ it.
i'm sure i'm not first 1 think of this, has seen before? i'm looking point me in right direction. i've searched stackoverflow, github , lots of google searches, no luck.
you did not need python task, bash script or batch file more sufficient, can write command in scheduler
but requested python code can run excel , open file:
from subprocess import call call(r'c:\program files\microsoft office\office15\excel.exe d:\documents\servers.xlsx')
this code opens servers.xlsx documents folder on d: drive beware of r
before string passed call function, if not provided should use \\ instead of \
Comments
Post a Comment