I've created a variable in sub test1() with name foldername. This will create a folder with name 071919 in specific directory for example. This sub test1() will call another sub test2() which will produce an excel file. I want to save the excel file produced by sub test2() to the folder 071919. so how can I apply variable foldername in subtest2()?
Dim foldername As String
Please Login or Register to view this content.