Greetings,
The following code successfully creates new workbooks
and separately
However, I would like the macro to save the file in the following naming convention: mm.dd.yy-0000-(worksheet name).
- the "0000" is in 24-hr time format
- I have two file format requirements (for separate reports). So please include the code for .txt file format, and separately include the code for .csv file format
Example1: 07.16.21-0228-AE Upload.csv
Example2: 07.16.21-0228-FFIL.txt
Thanks.
The following code successfully creates new workbooks
VBA Code:
Sheets("AE Upload").Copy
Cells(1, 1).Sort Key1:=Columns(2), Order1:=xlAscending, Orientation:=xlTopToBottom, Header:=xlYes
Range("A1").Select
and separately
VBA Code:
Sheets("FFIL").Copy
Cells(1, 1).Sort Key1:=Columns(4), Order1:=xlAscending, Orientation:=xlTopToBottom, Header:=xlYes
Range("A1").Select
However, I would like the macro to save the file in the following naming convention: mm.dd.yy-0000-(worksheet name).
- the "0000" is in 24-hr time format
- I have two file format requirements (for separate reports). So please include the code for .txt file format, and separately include the code for .csv file format
Example1: 07.16.21-0228-AE Upload.csv
Example2: 07.16.21-0228-FFIL.txt
Thanks.