Solved

Downloader 3

Posted on 2014-01-06
7
179 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 26

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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 26

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

706 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

19 Experts available now in Live!

Get 1:1 Help Now