L Leif Rasmussen Sep 3, 2003 #1 How to make VBA code that export Excel data to a Note pad file as comma sep. value ? Kind regards Leif
How to make VBA code that export Excel data to a Note pad file as comma sep. value ? Kind regards Leif
B Bob Phillips Sep 3, 2003 #2 Leif, The SaveAs method has a FileFormat property which you can set to xlCSV in VBA. For example Activeworkbook.SaveAs Filename:="C:\Test", FileFormat:=xlCSV
Leif, The SaveAs method has a FileFormat property which you can set to xlCSV in VBA. For example Activeworkbook.SaveAs Filename:="C:\Test", FileFormat:=xlCSV
