+ Reply to Thread
Results 1 to 4 of 4

How to download the zip file from internet explore and save it into c:\ using VBA codes

Hybrid View

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Post How to download the zip file from internet explore and save it into c:\ using VBA codes

    Hi,

    Someone please help me to download the zip file from internet explore and save it into c:\ using VBA codes.

    I have tried many codes from the internet but none of them are working. i am facing problem for the popup box. the macro which i have found was not supporting to it.

    Please find the source data from my web page.

    Let me know please, its urgent

    <!--STTAG-->File Options
                         </a>
                     </td>
               </tr>
     
                <SCRIPT>PrintFileURL("E_Survey_Pulse_Raw%20Data", "E_Survey_Pulse_Raw Data", 1, "0", "May 14 03:10 ", "/icons/dir.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("CallVol_ANZ_FY15_NCRxls.zip", "CallVol_ANZ_FY15_NCRxls.zip", 0, "366716", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("CallVol_SA_FY15_NCR.zip", "CallVol_SA_FY15_NCR.zip", 0, "3080948", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("FY15%20Real%20Time%20Update%20Report%20(Onsite%20&%20CIS)_NCR.zip", "FY15 Real Time Update Report (Onsite &amp; CIS)_NCR.zip", 0, "8916845", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("FY15%20Weekly%20Cnt,%20ESurvey,%20Telesurvey,%20ETA%20Report_NCR.zip", "FY15 Weekly Cnt, ESurvey, Telesurvey, ETA Report_NCR.zip", 0, "2168850", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("FY15%20Weekly%20Dispatch,%20Complete,%20CustDefer,%20OpenCall,%20DTC%20(Onsite%20&%20CIS)_NCR.zip", "FY15 Weekly Dispatch, Complete, CustDefer, OpenCall, DTC (Onsite &amp; CIS)_NCR.zip", 0, "5931184", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("FY15%20Weekly%20Fusion%20Report_NCR.zip", "FY15 Weekly Fusion Report_NCR.zip", 0, "396336", "May 15 05:05 ", "/icons/default.gif")</SCRIPT>
    <SCRIPT>PrintFileURL("FY15%20Weekly%20RMA%20Report_NCR.zip", "FY15 Weekly RMA Report_NCR.zip", 0, "127951", "May 14 05:23 ", "/icons/default.gif")</SCRIPT>
     
                <tr>
                   <td colspan="4" bgcolor="#CCCCCC" cellspacing="0" cellpadding="0" border="0">&nbsp;</td>
                </tr>
                <tr>

  2. #2
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: How to download the zip file from internet explore and save it into c:\ using VBA code

    Any One Please Advise....

  3. #3
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to download the zip file from internet explore and save it into c:\ using VBA code

    There seems to be information missing.
    What is this code you have here?

    Do you need to download all zip-files listed?
    Is the first "blabla.zip" the filename and the next description?

    If yes. I would find first ".zip" and the search backwards for " and that would give you the filename.

    Isn't C: a blocked 'foldet' on newer windows?

  4. #4
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: How to download the zip file from internet explore and save it into c:\ using VBA code

    Still, I dont have any code for it.

    If you can assist, so please provide me the correct code. which applies through File Download Popup Box.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Download CSV file from https:// internet
    By chinraj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 08:23 AM
  2. How to stop the internet explore pop up ?
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2013, 08:10 AM
  3. code for saving file from Internet Explore
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2011, 07:06 AM
  4. [SOLVED] Download a CSV file from an internet site
    By Microchip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2006, 07:45 AM
  5. How to write a micro to download file at a URL save the file at the local PC
    By www.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2006, 10:21 PM

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