+ Reply to Thread
Results 1 to 3 of 3

macro for automated download file from http login required

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2003
    Posts
    24

    macro for automated download file from http login required

    1. I want to create an automated program that can download multiple files from specific URL that requires login session to download
    2. File to download will be in .CSV or .XLS
    3. I want to edit a few things like tab name or file name and save it to .XLS to a specific location on my drive
    4. For some I want to copy a specific row and paste it to another existing file

    any idea?

    Please Login or Register  to view this content.
    I've tried this so far and i get it to login and start file download but I have to go through IE popup (open save cancel) and do all other stuffs myself

    I've tried using other people posted code however the file requires login. So it won't work

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: macro for automated download file from http login required

    Hello hellowit,

    Welcome to the Forum!

    To help you with this I need to the HTML source of the login page. You can either post the URL or post the source of the web page as a text file. If it exceeds the limit for uploading a text file then zip the text file and post it.

  3. #3
    Registered User
    Join Date
    05-02-2012
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: macro for automated download file from http login required

    Quote Originally Posted by Leith Ross View Post
    Hello hellowit,

    Welcome to the Forum!

    To help you with this I need to the HTML source of the login page. You can either post the URL or post the source of the web page as a text file. If it exceeds the limit for uploading a text file then zip the text file and post it.
    sorry the site is confidential so i can't give you much info. There are Username and Password field and a button for login. Can't use Submit function need to click the button to login because it link to some code.

    Please Login or Register  to view this content.
    i did get pass login. my idea is that i need to use the same IE window that i logged in to download the file. So i try navigate to the file URL and it popups download window that ask whether to save open or cancel. If there are a code to auto save when popup i think it will do

+ 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