PartTimeExcel
New Member
- Joined
- Dec 9, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi, I'm trying to SaveAs in VBA and make an .CSV file. When I do, I'm getting it to save in the correct path, but with an extension of ".21" (because of the date element?) My code is below. Any ideas?? Thanks!
ActiveWorkbook.SaveAs "\\server\2021 Imports\PP Import " & Format(Now, "mm.dd.yy") _
, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.SaveAs "\\server\2021 Imports\PP Import " & Format(Now, "mm.dd.yy") _
, FileFormat:=xlCSV, CreateBackup:=False