View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ayato[_5_] Ayato[_5_] is offline
external usenet poster
 
Posts: 1
Default how to hide .CSV file extension ?

TroyW wrote:
*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/
*



Hi Troy,

This is what I am using..

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