Excel VBA macro to use cell data from a non active sheet to save the Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-3016882%22%20slang%3D%22en-US%22%3EExcel%20VBA%20macro%20to%20use%20cell%20data%20from%20a%20non%20active%20sheet%20to%20save%20the%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3016882%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20question%20while%20waiting%20for%20the%20first%20lesson%3A%3C%2FP%3E%3COL%3E%3CLI%3EHow%20can%20I%20save%20please%20an%20Excel%20Workbook%20on%20a%20company%20network%20(where%20each%20user%20is%20assigned%20a%20disk%20space%20%E2%80%9CFirst%20name%20Last%20name%20%E2%80%93%20OneDrive%E2%80%9D)%20that%20is%20created%20from%20a%20VBA%20macro%2C%20using%20today%E2%80%99s%20date%20in%20YYMMDD%20format%20along%20with%20the%20first%20twelve%20characters%20of%20two%20fields%20in%20one%20of%20the%20non-active%20worksheets%20that%20are%20a%20part%20of%20the%20Workbook%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20file%20to%20be%20saved%20into%20the%20SAFER%20directory%2Ffolder%20which%20in%20turn%20should%20resideas%20follows%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%E2%80%9CFirst%20name%20Last%20name%20%E2%80%93%20OneDrive%5CSAFER%5CYYMMDD%20aaaaaaaaaaaa%20bbbbbbbbbbbb.xlsm%E2%80%9D%E2%80%9D%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again%20%E2%80%93%20I%20look%20forward%20to%20your%20response%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3016882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a question while waiting for the first lesson:

  1. 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

0 Replies