Save a File to specific location RRS feed

  • Question

  • Hi Friends,

    I have automated a web site through VBA(MS Access).

    It has a link button called download when it is clicked a file would be downloaded.

    I want VBA code to automate saving the file to specific location.

    Advance Thanks.

    Thursday, March 20, 2014 3:07 PM

All replies

  • Are you talking about browser click or Access Form click?

    Happy to help ! When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answered

    Thursday, March 20, 2014 3:44 PM
  • There is a link button on web site. I am clicking that button through VBA Code.

    When it is clicked i am geting a message where to save the file. Here, i dont want this message to appear.

    the file should directly saved to some specific location when the link button is clicked.


    Thursday, March 20, 2014 7:59 PM
  • I don't think you can override the browser behavior.  This behavior is not controlled by the DOM.  You can set the save directory in the browser.  I think I used sendkeys to force a save and then moved the file after it was saved.
    Thursday, March 20, 2014 10:33 PM