[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Downloader 4.1

Hi Experts,


I have one file which downloads file from site which is pack files. I wan to add one more procedure while downloading - Download for 1st date - unpack - replace column D with Date for which it is downloaded - save - Next Date Same way.

one more thing current code produce date in workbook, which is not required, if possible pls remove it.


see attached file

Thanks
Test--Downloader-4-.xlsm
0
Naresh Patel
Asked:
Naresh Patel
  • 7
  • 3
1 Solution
 
als315Commented:
Test first part: download, unpack, delete zip
Test-Downloader-4-1.xlsm
0
 
als315Commented:
Test whole task
Test-Downloader-4-1.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Sir Alexey,

Yes part I Clear

but it is not possible this way - Download one file - replace Columns - save - Next Date.


Two things still remainingColumn Replace& if it is possible Dates In Main Sheet
Thanks & Sorry For Delay Reply.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Naresh PatelTraderAuthor Commented:
Again Sorry I had open IE tab (remain open while I typing & creating screen shot) & posted my comment & after that I saw your comment.
0
 
Naresh PatelTraderAuthor Commented:
Sir Alexey,

What you want me to do Accept & Waite for modified?
Dates
it makes not much different.

Thanks
0
 
als315Commented:
Test without dates on main sheet
Test-Downloader-4-1.xlsm
0
 
Naresh PatelTraderAuthor Commented:
As Usual Excellent
0
 
Naresh PatelTraderAuthor Commented:
Sir Alexey,

Will you pls look in to my this question Math2 as I don't know commented expert is working on  or not? it open since last 13 Days. Even I don't know he is understand what am I trying to do. Generally I never invite other expert if I am working with some one in particular question, No matter how much time it takes to resolve but in this, I dint find feedbacks. "I am not complaining." if in my post anything against EE Rules - apology
Inviting you - Accept if you feel so.

Thank You
0
 
Naresh PatelTraderAuthor Commented:
Sir Alexey,


This regarding this question.
see attached want to download for year 2000 but It wont. in previous files I change  "i Year" in code & download file for that particular Year but in this case I don't? is there any way to download from start date to end date with more than 1 year ?

Thanks
Test-Downloader-4.1-V-1.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Sir cant download for the year 2000...



thanks
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now