Saving CSV File

bobnavision
bobnavision Member Posts: 159
edited 2006-03-21 in NAV/Navision Classic Client
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,

Comments

  • SteveO
    SteveO Member Posts: 164
    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.
    This isn't a signature, I type this at the bottom of every message
  • bbrown
    bbrown Member Posts: 3,268
    Use xlWorkbook.SaveAs(Filename, FileFormat)
    There are no bugs - only undocumented features.
  • kriki
    kriki Member, Moderator Posts: 9,121
    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
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories