Hello,
I'm trying to save a file at work on a daily basis in a folder and I want to use VBA.
However, the date in the file name changes daily and there are subfolders for every month and another subfolder for everyday.
The path where I want to save is:
\\nfpgshare-1.ed.com\export\shareholder_acc\629\629 Share Class\Name\Trade\2021
the subfolder would be 01-January, 02-February, etc
The title of the document would be "629 Shares TD mm.dd.yy"
Please include explanations so I can do this in different scenarios, such as if there was a daily folder within the monthly folder.
Thank you
I'm trying to save a file at work on a daily basis in a folder and I want to use VBA.
However, the date in the file name changes daily and there are subfolders for every month and another subfolder for everyday.
The path where I want to save is:
\\nfpgshare-1.ed.com\export\shareholder_acc\629\629 Share Class\Name\Trade\2021
the subfolder would be 01-January, 02-February, etc
The title of the document would be "629 Shares TD mm.dd.yy"
Please include explanations so I can do this in different scenarios, such as if there was a daily folder within the monthly folder.
Thank you