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!
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.
|Macro to Lock and Unlock a Worksheet ONLY||12||33|
|Excel conditional formating based on a date, in a cell with a formula||22||27|
|Word VBA, Clear CheckBoxes in VBA Form||4||34|
|Delete row if does not start with 0||43||35|