?
Solved

Downloader 3

Posted on 2014-01-06
7
Medium Priority
?
197 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:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 27

Expert Comment

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

Author Comment

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




Thanks
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 600 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
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 27

Accepted Solution

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

Author Comment

by:Naresh Patel
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:Naresh Patel
ID: 39762052
Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39762082
This Is The Link  Downloader 4




Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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