Hi,
How do I get the below to save in the same folder the file is located in? If this is located in desktop/macro folder how can I have this output to also save in that same folder rather than My Documents?
![]()
ThisWorkbook.Sheets("Sheet3").Copy ActiveWorkbook.SaveAs Filename:="CSV_STS_Feed_" & FYear & FMonth & FDay, FileFormat:=xlCSV, CreateBackup:=True ActiveWorkbook.Close
Bookmarks