• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Scheduled Task to run macro to update links doesn't work

    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...
  2. S

    Scheduled Task to run macro to update links doesn't work

    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...
  3. S

    Can excel pull from a different workbook if it is closed, but in the same folder

    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...
  4. S

    Scheduled Task to run macro to update links doesn't work

    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...
  5. S

    Scheduled Task to run macro to update links doesn't work

    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...
  6. S

    Scheduled Task to run macro to update links doesn't work

    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...
  7. S

    Scheduled Task to run macro to update links doesn't work

    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...
  8. S

    Scheduled Task to run macro to update links doesn't work

    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...
Back
Top