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
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
I figured it out it is DDMM.

Pls check the file for Delivery BSE if all ok.
gowflow
Incoporated-Download-File-V04.xlsm
0
 
gowflowCommented:
Yes will revert give me sometime
gowflow
0
 
Naresh PatelTraderAuthor Commented:
Sure Sir,
I'll be waiting for your reply.

Thanks
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
gowflowCommented:
By the way is this also a 2 step zip and unzip ?
gowflow
0
 
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
 
Naresh PatelTraderAuthor Commented:
Perfect
0
 
Naresh PatelTraderAuthor Commented:
This is follow up Link BDel Formatting".

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.