Notepad and Excel

L

Leif Rasmussen

How to make VBA code that export Excel data to a Note pad
file as comma sep. value ?

Kind regards Leif
 
B

Bob Phillips

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
 
Top