how to use the variable defined in another sub

Hi,

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.

Thanks, Haluk,

The way you mentioned above works for the 2 subs in the same workbook. My situation is I have one variable foldername defined in workbook1 sub test1() that will create a folder with name 071919 and open another workbook, workbook2. and sub test2() within workbook2 will create an excel file that I want to save to the folder that created in sub test1() 071919. so any idea for this variable declaration?

Thanks, CK76

I don't understand what you mean for those 3 options. I give my situation in more detail here. My workbook1 have a cell value "IMF ICCB 071919". The variable and code in sub dur_step_1() reformat this value and create folder 071919 in directory.

Please Login or Register  to view this content.

Actually another sub IMF_Duration() within this workbook1 will open another workbook, workbook2.

Please Login or Register  to view this content.

The sub IMF_reformat_new() within workbook2 will create a workbook that I want to save to the same folder I created before 071919.

Please Login or Register  to view this content.

You can see I defined variable "foldername" in sub dur_step_1, but the same variable I used in Sub IMF_reformat_new() does not work.

Btw, can you explore more about option 1 and 2? or do you have any resources I can see if this is more convenient.

Thanks. I think this is the way I am looking for. Since I am not quite familiar with this way, when I try to duplicate the above code, it does not work. I will speculate it and see how I can apply. I will get back if I cannot solve this issue.