?
Solved

Download BDel

Posted on 2015-01-07
10
Medium Priority
?
139 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

771 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