AhmedAbbas
New Member
I have a file extension like this
H:\Accounts\Mthly Report\FY 2017\07.2017\WESTPAC\JUL_2017 Westpac Bank Statement.xlsx
Lots of file directory remains the same but few things changes
For example Year 2017 Month 07 or Jul
I have used following formula to determine the variables
=TEXT(TODAY(),"mm") Placed in Cell A1
=TEXT(TODAY(),"yyyy") Placed in Cell B1
=TEXT(TODAY(),"mmm") Placed in Cell C1
Question is how can I create a string using these variables to reach the file named above. Your guidance is much appreciated
H:\Accounts\Mthly Report\FY 2017\07.2017\WESTPAC\JUL_2017 Westpac Bank Statement.xlsx
Lots of file directory remains the same but few things changes
For example Year 2017 Month 07 or Jul
I have used following formula to determine the variables
=TEXT(TODAY(),"mm") Placed in Cell A1
=TEXT(TODAY(),"yyyy") Placed in Cell B1
=TEXT(TODAY(),"mmm") Placed in Cell C1
Question is how can I create a string using these variables to reach the file named above. Your guidance is much appreciated