Using cell reference as part of file location

[gt213]

I have the following code that I use to retrieve txt files saved in a folder called Text Files:

Const fPath As String = "C:\Int\Equal\Game\Open\Text Files"

There is then further code used to identify and open the files I need, I don't that that is relevant for what im trying to do, which is this:

I want to have further folders within "Text Files" which will contain the files that I want to open, and reference the name of this folder through cell B2 on a worksheet called "Control". Here is what I have tried but I am getting a compile error:

Const fPath As String = "C:\Int\Equal\Game\Open\Text Files" & Worksheets("Control").Range("B2") &""

Appreciate any help.

 

[wideboydixon]

Hi there,

The "Const" keyword indicates a constant - i.e. something that can't change according to a cell value. Try this instead:

Dim fPath As String
fPath = "C:\Int\Equal\Game\Open\Text Files\" & Worksheets("Control").Range("B2").Value

WBD

 

[gt213]

Thanks, that works great!