unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Excel Gurus,
I'm looking for some post here regarding naming of files but can't find a suitable one.
Basically I have these folders on my documents:
Folder 1: Math
Folder 2: Science
Folder 3: History
Inside the folders are different files like in the form of PDF, Excel, Text,jpg and Word. Example of files inside "Math folder":
Pupil1.xls
Pupil2.txt
Pupil3.docx
Pupil4.pdf
I was thinking to create a macro renaming the files by batch:
Macro Worksheet:
<tbody>
</tbody>
Sample Output saved on the same folder (for Math):
Pupil1-Math-063019.xls
Pupil2-Math-063019.txt
Pupil3-Math-063019.docx
Pupil4-Math-063019.pdf
The Folder name was added= "-Math" & Date "-063019" in the file.
Any thoughts will be much appreciated.
I'm looking for some post here regarding naming of files but can't find a suitable one.
Basically I have these folders on my documents:
Folder 1: Math
Folder 2: Science
Folder 3: History
Inside the folders are different files like in the form of PDF, Excel, Text,jpg and Word. Example of files inside "Math folder":
Pupil1.xls
Pupil2.txt
Pupil3.docx
Pupil4.pdf
I was thinking to create a macro renaming the files by batch:
Macro Worksheet:
Folder Name | Folder Directory | Date | Macro Button |
Math | F:\User\unknown\Documents\Math | 063019 | Click Macro |
Science | F:\User\unknown\Documents\Science | 063019 | Click Macro |
History | F:\User\unknown\Documents\History | 063019 | Click Macro |
<tbody>
</tbody>
Sample Output saved on the same folder (for Math):
Pupil1-Math-063019.xls
Pupil2-Math-063019.txt
Pupil3-Math-063019.docx
Pupil4-Math-063019.pdf
The Folder name was added= "-Math" & Date "-063019" in the file.
Any thoughts will be much appreciated.