Refer Folder/Filename in VBA code through Named cell reference

[acsishere]

Dear Friends,

I have the following codes in which I am to refer a file and folder to do some further processes.

myfilename = "C:\Documents and settings\acs\My Documents\Entry\myfile1.xls"
folderPath = "C:\Documents and settings\acs\My Documents\Entry\"

I want to enter these two paths in a sheet in my excel report file (For example, I am running the report from Report1.xls, in which there is a sheet name "Filepaths". In this,

in B5, I would like to enter the Filepath (B5 named as "FILEPATH")
in B6, I would like to enter the Folderpath (B6 named as "FOLDERPATH")

So that, if I am copying the folder to another area, I no need to change the code every time in the VBA editor. I can do changes in these cells and it will be taken as the path to run the code further.

Sincerely waiting for your kind reply,

Thanks in advance,

acsishere.