Saving CSV File

bobnavision

Hi,

How do we save a CSV file through code on local disk.
I used code
xlWorkbook.SaveCopyAs("C:\Pick.CSV");

This code saves the file with extension CSV but its an excel file. Because when you open this file and do save as , on Save As window, it shows type=excel.

Also when you open in text , it doesn't open the same way as CSV.

Regards,

SteveO

Why not just write straight to a file and seperate the values yourself? That way you don't need to worry about using Excel Automation, you can just use the built-in Navion file handling routines.

bbrown

Use xlWorkbook.SaveAs(Filename, FileFormat)

kriki

PS : in case you then want to import it into Navision with a dataport, it is better to use tab-separated files
http://www.mibuso.com/forum/viewtopic.php?t=8312
http://www.mibuso.com/forum/viewtopic.php?t=7209