• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

Download BDel

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
Naresh Patel
Asked:
Naresh Patel
  • 5
  • 5
1 Solution
 
gowflowCommented:
Yes will revert give me sometime
gowflow
0
 
Naresh PatelTraderAuthor Commented:
Sure Sir,
I'll be waiting for your reply.

Thanks
0
 
gowflowCommented:
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!

 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
yes I do.
0
 
gowflowCommented:
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
 
gowflowCommented:
I figured it out it is DDMM.

Pls check the file for Delivery BSE if all ok.
gowflow
Incoporated-Download-File-V04.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Perfect
0
 
Naresh PatelTraderAuthor Commented:
This is follow up Link BDel Formatting".

Thanks
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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