Does this do what you want?

Workbooks("theworkbooknamehere").SaveAs "thefilename.100", xlCSV

Troy

"Ayato " wrote in message
...
Hello @ll,

I have a macro that saves ".xls" as ".csv" but how can I hide the
".csv" extension (and use for example an extension ".100", and not
".100.csv")

regards,
Ayato


---
Message posted from http://www.ExcelForum.com/