+ Reply to Thread
Results 1 to 3 of 3

Change Save As path on the download file box (VBA and API)

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    Dallas, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Change Save As path on the download file box (VBA and API)

    I am trying to automatically download some pdfs off of our companies website and unfortunately the company has it set up in such a way that the only way to me to automate the download process, I have to write VBA code to go through the save as file box method. In the screenshot below, does anyone know how to write code to change the "C:\Users\srn5\Downloads" to another path say "M:\StatementDocs\2013\" ?

    Also, does anyone know how to rename the file in that box from "Deca_Written_statement" to lets say "Deca"?


    SaveAs.jpg

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Change Save As path on the download file box (VBA and API)

    re-read the question....and looked at the image you are after Chrome help

    https://support.google.com/chrome/answer/95574?hl=en-GB
    this link to change default download location
    however it will change it for everything

    second part...you have to rename yourself or get some 3rd party renaming software....beyond scope of these forums really
    Last edited by humdingaling; 06-03-2013 at 10:14 PM. Reason: Question not even Excel VBA

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    Dallas, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Change Save As path on the download file box (VBA and API)

    The problem is i want the download location to be dynamic. I don't want it to always go to the same folder. Basically, i'm trying to write a macro that will go to multiple sites and download them to the appropriate folder.

    Also, the macro will be using IE rather than chrome.
    Last edited by aqpham3; 06-04-2013 at 10:15 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1