Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
394 views
in Technique[技术] by (71.8m points)

taskscheduler - Re-use existing Excel process when opening a workbook through Task Scheduler

I have an excel file I should open every day to keep track of my work. Sometimes I forget to open it, so in Task Scheduler I have a scheduled task for each work day to open the file. To do so, you have to provide the full path to excel as well. Now if Excel is already running because I started work already, or because the laptop is still open from the day before, a new Excel process is started. Since I also have a personal macro workbook that is opened hidden in the background, I get "complaints" from the new process that is opened through the task scheduler because the file is locked by the other process. Is there a way (even without task scheduler) to open an excel workbook in an existing process if there is one?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...