Hi there,
I've created a folder with the files on Dropbox for you. However, I need to provide an email address to share the folder with you. It does not just give me a general link. Do you have an email address I can send it to? Or is there another option?
I've uploaded the task...
Hi,
Yes I confirm that all the 5 items listed above are happening. For C - the 2 excel files are time stamped as of today because they are saved via the macro. However, the links are not updated in the actual files.
There is nothing that differs when running the scheduled process vs the...
Hi there,
Have you tried the PULL function? This works in updating links to closed workbooks. Its not a formula in Excel but a combination of VBA and native Excel processes. There is some VBA you have to download online and paste in your workbook for it to work. I've used it in the past...
Hello again,
In Actions, it does say Start a Program.
The "Program or Script" is the following: "cgassv0001revenueDSSScheduled JobsMissions_Club_Med_Artists_2010.vbs"
There is nothing in Add Arguments.
When I go to the History tab (the 6th tab), there is nothing in there, which is...
Yes, it is a .vbs file. I'm not sure what you mean by task scheduler action configuration and the returned code. I don't know where to find that. The action just points to where the .vbs file is located. When we set it up, we just set up the trigger and the action.
The below refers to our...
Hello!
This is the whole script:
Dim oWshShell
Dim oAccessApp
Dim oExcelApp
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "C:AppwinPComPrivateCM.ws", 1
wscript.sleep 10000
'**************************************************
'****** Access...
Hi,
Thank you for your reply. I've searched and nothing seems to come up regarding my specific issue.
The scheduled task calling procedure is in the Windows Task Scheduler. It is scheduled to run at a specific time every day. The scheduled task seems to run without a problem. However...
Hello,
I have set up a scheduled task to update links in a workbook. This scheduled task just calls a macro in the workbook that updates external links. The problem I am having is that the scheduled task does not want to update the links. It only works when I run the macro directly from the...