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.

[XiaoWei]

Include this code at top of the procedure

Dim fileName As String, folderPath As String

fileName = ThisWorkbook.Sheets("Filepaths").Range("B5").Value
folderPath = ThisWorkbook.Sheets("Filepaths").Range("B6").Value

Then in the remaining statements, use the variable names fileName and folderPath. You can change variable name to your likings.

[heathb]

Include this code at top of the procedure

Dim fileName As String, folderPath As String

fileName = ThisWorkbook.Sheets("Filepaths").Range("B5").Value
folderPath = ThisWorkbook.Sheets("Filepaths").Range("B6").Value

Then in the remaining statements, use the variable names fileName and folderPath. You can change variable name to your likings.

Hi, how can you concatenate the folder

I have a folder that sections change each month
so folder path = C:\contant1\constan2\YEAR\QUARTER\constant3\

my user would change the YEAR and QUARTER in sheet1 fields B5 & C5,

I have seen the work sheet concatenating these into one, but cannot remember how.

once the above script runs, I want to be left in the original file to complete the macro

Any help, many thanks

[DonkeyOte]

myfilename = Sheets("FILEPATHS").Cells(5,2)

or using named range

myfilename = Range("filepath")

[arlu1201]

heathb,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.