I find it easier to manipulate data to different cells as required using appExcel.application and .Activecell.offset. I also define cell names in the templates so I can easily focus where to start the writing from.
Thank you for your direction so far and I have been able to save it as csv, for any one stumbling upon this in the future, I have used :
appExcel.ActiveWorkbook.SaveAs FileName:=CsvFileName, FileFormat:=23
'// where CsvFileName is a variable that stores the full path and the intended file name ending with csv and the number 23 represents the excel fileformat for windows csv
I have got a slight problem, the client end of this report is demanding each field in the csv come wrapped in " " (double quotes), while saving it from excel just outputs the standard field contents. Would you know of any approach in doing it ?
Secondly, I dont know if this warrants a separate question ( I would be happy to do this), is there a limitations in the number of fields a query can have in acces, or a limitation in number of empty fields in access >
Thank you for your help so far