Solved

Downloader 3

Posted on 2014-01-06
7
181 Views
Last Modified: 2014-01-07
Hi Experts,


Need to Download Files from start Date to End date from one web site. Will you guys help me out on this.Del

In this link if I manually change "/SCBSEALL0601" to "/SCBSEALL0301"
& past to chrome browser it automatically download file that this date i.e. 3 Jan 2014 with prompting of any clicks.

I have sample file for this kind of process but link is different.

Thanks
Test.xlsm
0
Comment
Question by:itjockey
  • 4
  • 2
7 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39761715
Here you go.
Test.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 39761937
Not Woking Sir......there is no files in "C:\Test\"




Thanks
0
 
LVL 39

Assisted Solution

by:als315
als315 earned 150 total points
ID: 39761983
No points: there is small error in MacroShadow's code. Add one line in the beginning of Do Loop:
strFileName = "SCBSEALL" & strDate & ".zip"
immediately after
strDate = Format(datWorkDate, "ddmm")
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 27

Accepted Solution

by:
MacroShadow earned 350 total points
ID: 39762021
Thank you als315.
Test.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 39762047
Thank You Both Of You.....it is working.....   :) there is one more question in line & defiantly last one. if you feel to be a part of it .....highly appreciated ...Thanks
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 39762052
Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 39762082
This Is The Link  Downloader 4




Thanks
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now