Naresh Patel
asked on
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
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
ASKER
Sure Sir,
I'll be waiting for your reply.
Thanks
I'll be waiting for your reply.
Thanks
By the way is this also a 2 step zip and unzip ?
gowflow
gowflow
ASKER
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
Thanks
Will first do zip and unzip in this question. Pls one at a time can only do so much. I hope you agree
gowlfow
gowlfow
ASKER
yes I do.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect
ASKER
gowflow