Solved

Follow Up

Posted on 2015-02-04
13
107 Views
Last Modified: 2016-02-11
Hi experts,

This is follow up question.
A   I have WB with buttons which download data from web and store in location which is mention in sheet Setting".
but many time I clicked on button it store to "D:\AmiBroker Data\Files\Temp". if there is Temp folder doesn't exist it will be created and store files.

B   Code format data after downloading but some time files are not come in the usual format so process stop that time and come up with error and have to stop the process. so again if I have to download from start date to previous date of corrupt file. I had tried to download for 8 years daily data but one file corrupt. have to start from very first year as in every button it delete past files. So there is any way to register those file names in column G and remain that file as it is and go ahead with next. so I will manually format that files.

Capture.PNG
See attached file.
Incoporated-Download-File-V17.xlsm
14032014.csv
18032014.csv
0
Comment
Question by:itjockey
  • 7
  • 6
13 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40589760
Easy,

Instead of all this impossible complicated issues to keep track that is an total overkill !!!

We simply, like it was originally designed, each and every time it is about to delete files it will simply ask for your confirmation !

If you say No, then the files will be added to the directory if yes it delete the files in the directory !

how about that ?
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40589797
and for the Temp directory sorry My mistake I forgot to remove the trace this is how I test your data !!!

Open your latest workbook goto VBA and doubleclick on Thisworkbook it should be like that:

Private Sub Workbook_Open()
'bTesting = True
Sheets("Main").Activate
End Sub

Open in new window



You should have btesting commented out (single quote in the beg and it being green !!!) or else you get the Temp unique directory and here goes the whole data getting deleted !

gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40590738
As I noticed in every segment only 4 to 5 files is in wrong format out of 1000 files in each segment, which cause error. if we trace that files and named in column G it would be preferable. As after final files I need this files only for 2 min to upload in my software ...after this it is no use . so error files by pass and named in column G is best situation ...still if it is spagatti programing then chose what ever you like.

Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 40590862
Directory thing is solved.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40590970
Well can you give me a date for a wrong file so I try to upload to see what kind of error as cannot know just by saying error where it blocks !!!

Do you have errors in each and very button ? or some only ? which one ?
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40591031
Very first button NSE Delivery ....date is 14 March 2014.

I had tried this only for long duration.And yes NSE equity tried but excel closed automatic. I will run again and let you know. May I guess it is because of My laptop processor I.e. Atom processor .

Thanks
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 29

Expert Comment

by:gowflow
ID: 40591047
Will try and let you know.
gowflow
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 40591070
don't know about the delay but I got an error that is not due to the file but a mis-handling in the routine that is fixed in this version.

Pls try it for date 14/03/2014 for button Delivery.
What I did is put 14/3/2014 in Start Day and 15/3/2014 in End date and after running it you can then put back in End Date =Today().

Let me know.
gowflow
Incoporated-Download-File-V19.xlsm
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40592047
If any problem I will post here ....as far as this question ......It is solved ....

Thank you very much Sir.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40593155
Your welcome.
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40614197
Need your favor..... may I?
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40614268
yes pls shoot
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40614342
Here It Is.

Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now