Take folder name found in specific cell for VBA code

[Nick70]

Hi,

I have a piece of code that refers to a specific folder in a directory.

The folder's name is that of the month it refers to and changes every month ( (e.g. October, November December etc.).

Rather than me changing the code each month with correct month name I wanted to point the code to a specific cell in active workbook (let's say cell B4 in Sheet1) that contained the month I would like to look at.
So instead of changing the name of the month in the code I would just type new month name in that specific cell (i.e. B4 in Sheet1).

Code below:

'   Set filepath
    fPathSrc = "P:\Lonib\Inter-department\Client Verification\06_Workflow Coordination\Reviewer's checklist\December\"           'Source file path

In example above the path points to month folder 'December'.
I would like to be able to change code so that the word December at the end of the path is taken from cell B4 in Sheet1 which I would type in manually.

How would I do that?

Thanks,
Nicola

 

[Joe4]

Try this:

'   Set filepath
    fPathSrc = "P:\Lonib\Inter-department\Client Verification\06_Workflow Coordination\Reviewer's checklist\" & Sheets("Sheet1").Range("B4") & "\"

 

[Nick70]

That worked perfectly.

Thanks!
Nix

 

[Joe4]

You are welcome.