Thread: how to hide .CSV file extension ?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ayato[_6_] Ayato[_6_] is offline
external usenet poster
  
Posts: 1
Default how to hide .CSV file extension ?
This is code I use :

'save as Agent Report
ActiveWorkbook.SaveA
Filename:="C:\Reporting\Apple\Agent\24nl_agent." + savedate + "", _
FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close SaveChanges:=Fals

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

Reply With QuoteReply With Quote