Solved

Downloader 3

Posted on 2014-01-06
7
184 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

803 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