[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Download BDel

Posted on 2015-01-07
10
Medium Priority
?
152 Views
Last Modified: 2015-01-08
Hi Experts,

I have one link which download file from server. I need one WB VBA code in which I put Start date and end date & it will download all files between this dates & save to this path "D:\AmiBroker Data\BSE\Del". it is zipped files need to unzip. after unzipping it is .txt files. need to do one thing in this files - Replace "|" to "," in all .txt files.

This Is The Link.

Thanks
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
  • 5
  • 5
10 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 40536489
Yes will revert give me sometime
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40536531
Sure Sir,
I'll be waiting for your reply.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40536667
By the way is this also a 2 step zip and unzip ?
gowflow
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Author Comment

by:Naresh Patel
ID: 40536674
Yes Sir ...Zip & UnZip as well as formatting also required. After unzipping all are .txt files. need to replace "|" to "," in all text files.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40536694
Will first do zip and unzip in this question. Pls one at a time can only do so much. I hope you agree
gowlfow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40536759
yes I do.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40538919
Here we are

Just s question
SCBSEALL0101.zip

0101 stands for 1 Jan ? ... and so on ? More precisely is the format of these files MMDD or DDMM ??
gowflow
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40539025
I figured it out it is DDMM.

Pls check the file for Delivery BSE if all ok.
gowflow
Incoporated-Download-File-V04.xlsm
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 40539469
Perfect
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40539473
This is follow up Link BDel Formatting".

Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

656 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