AndrewDrewAndy
New Member
- Joined
- Nov 18, 2019
- Messages
- 16
I have a workbook with 10 active files, but I only need to save sheets ("Export 1", "Export 2", "Export 3", "Export 4", "Export 5"). I have a file path I want to save them in, but I cannot find a code to save each sheets filename to the .txt in each sheets' C5 cell (each sheet has a different person's name that the file needs to be saved as). It doesn't work to change the worksheet names because the file is active and changes ofte