I have a question while waiting for the first lesson:
- How can I save please an Excel Workbook on a company network (where each user is assigned a disk space “First name Last name – OneDrive”) that is created from a VBA macro, using today’s date in YYMMDD format along with the first twelve characters of two fields in one of the non-active worksheets that are a part of the Workbook?
I want the file to be saved into the SAFER directory/folder which in turn should resideas follows:
- “First name Last name – OneDrive\SAFER\YYMMDD aaaaaaaaaaaa bbbbbbbbbbbb.xlsm””
Thank you again – I look forward to your response