0
votes

So I have a VBScript that works together with VBA in excel and does the automatic update of the model every day (bound to Task scheduler). Besides saving the excel file with the current date in the name, it also save a hard copy in a pdf format(also with a relevant date). After switching to Win 10, every time the script runs, the window pops up and asks - how would you like to open a file? Adobe, notepad, etc. pdf is by default opened by Adobe(set). So how can i get rid of that pop-up window? It defeats the whole purpose of automating the process and also prevents it from working properly, as after the pop-up, the pdf is not saved. Also, if I run the script through cscript via cmd, it all works fine, but if through task scheduler(also with cscript) than the problem persists. Any help?

1

1 Answers

1
votes

Taskscheduler has two modes to run tasks, one is using a specific account, the other is using the system account. Check which user runs the task, interactively logon with that user and make sure the standard program to be used with the .PDF extension is Adobe. Is the system account is used, change this to a specific user because you won't be able to do this with the System account. Try also running this task with the highest priority setting.