Hi GTji,
I have examined your sheet. It is still not clear as what exactly is the Run time error. Is it "Path not Found". If it is so then most probably it is because path of the Amibroker data is wrongly typed in. In your case it is "C:\Program Files\Amibroker\NEWDATA" just check if the same exists. The second Error in your sheet may be because of "subscript out of range" If this is run time error then you have remake the sheet from original sheet posted here.
One important suggestion is that make ur sheet as per ur required symbols and save it as a safe backup sheet. If at anytime error occurs during the running of sheet, just close the sheet without saving and restart the same. In fact what is happening some data is stored in hidden parts of the sheet for processing and if error occurs it interfears with fresh data on restart if sheet was saved. So if error occurs then close sheet without saving. On each successful operation sheet is saved automatically to keep the stored data ready for next operation.
Hope this will solve yor problem
Come back if there is still any problem
Rajeev