Still a grey area. I already have xlsx files that have 4 sheets as RAW wherein I paste the exploration results manually. The said 4 raw sheets are further linked to other sheets within the file as well as to number of other excel files that create shortlists. That’s why conditional formatting comes to the fore. As such a csv output may not technically help. And hence a restriction as far as batch file export is concerned.
A way around would be to create number of output files through batch process, link them further to the RAW files & then get the required output. But this would be error prone as any change in the basic afl &/or excel structure will need to be implemented at number of places. (Especially with functions like vlookup -> which do not dynamically change the column numbers if any changes are made to RAW files).
Hence requirement to write to particular sheets in an exel sheet.
Idea is not just to create specific shortlists but try permutation combination of various parameters while selecting the scrips to trade.
While on the matter, any basic synatx or READ for the OLE or VBA would certainly help.