Tell VBA script to look for info in a cell

[watery]

I have a macro which opens up files in specified folders. At the moment the filepath to the folder is hard scripted which is very annoying if the folder is moved. Is there a way of re writing the macro so that it looks at a cell for the filepath? That way it would only require changing one bit of info rather than dozens and dozens of occurences within the script.

Thanks.

[thomaspatton]

using the code you have, set a variable :

Dim OpenThis As String
OpenThis = "CellReference"

Then, you can change the cell reference to call the Variable using OpenThis.

[Bob Phillips]

Or you could a file dialog to alow the user to browse to the directory.