See: http://forum.equis.com/viewtopic.php?t=1063 wabbit :D

You should be able to save the whole workbook as csv (text). Perhaps there is something we could be doing in Excel to solve this problem, so that the conversion software works correctly? What are you doing with the Excel files? Where are the errors being generated? wabbit :D P.S. I am very curious about this one!

Wabbit, Sorry just looked at how I set my orinal files up. I export my files from sharescope as meta files, .prn extension. then convert using ascii text choose destination folder, click ok and away it goes, doesnt ask for ticker symbols, uses the file names automatically. Ill have to find away of saving as a text file in excel. Regards Robert

You know that feeling you get when youve cracked something (I dont meen your dinner plate), youre momment oh ureeker, and at the same time you realize you should take yourself to the garden and slap yourself with a wet fish. Well thats were I am now, and when I tell what I was doing wrong you to will want to slap me with a piece of.. that s enough of that anyway. When I imported my files into Excel you get the box apear asking you to set up the layout, ie date format, wether its tab or coma, which columns and if date or text etc. For some reason Id decided to import from column 2 onwards. This left out the ticker column. My mistake was I had convinced myself that when downloader converts, it takes the ticker from the file name, WRONG!!. As you probably know it takes it from within the file. I should have ralised this when it kept asking for a ticker name for each file, as when I set up my folders this never happened, and it is basically the same data. Anyway fixed it, wrote vba code to trim my data and rename my symbols, now working on putting them into the correct folders. Regards Robert

Sorted with the downloader in metastock. The conversion utility was good, but I only used the demo, so only did one file at a time. Regards Robert