file path reference using existing spreadsheet cells

shammer

New Member
Joined
Feb 26, 2002
Messages
25
Hello All,

I am hitting a wall when I try to use cells in my active spreadsheet to refer to a filepath of external source.

I am trying to reach the following filepath:

=+('G:EdFinExpA MC[filename.xls]tab'!B6)

So, I would like to input in cells A2, B2, C2, ..., I2 - the individual components to reach the target cell. I apparently do not know the correct symbols to use to link them all together.

Basically, only two of the inputs (the filename and the cell change periodically).

Any help on this one would be greatly appreciated.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
I am not entirly sure of what you are trying to do....but i think the best piece of advice passed onto me was to record a macro to do it then view the code and try to understand it and then apply it in future, And now i pass it on to you.

Hope it works
 
Upvote 0
I am trying to find a way to create a filepath by referencing the individual components of that filepath in other cells in the spreadsheet.

Basically I would like the cells in row 5 to refer to cells A1 through H1 to construct a filepath.

For example, if I want cell A5 to reference the following filepath:

'C:AssetsOctoberFUND1[daily 1015.xls]1234'!$J14

I would like cell A1 to contain the C: drive reference; A2 to contain the Assets folder reference; ... and cell G1 to contain the J14 cell reference.

I want to know how to construct the formula in cell A5 to construct this filepath by only referring to the cells in row 1.

Any help would be greatly appreciated!
 
Upvote 0
I have managed some success with this. I am able to get the text in cell A5 to spell out the filepath that I want, but I am unable to get the cell to pull the information that is contained in cell J14 within the other spreadsheet.

How do I get it to execute the filepath instructions?
 
Upvote 0

Forum statistics

Threads
1,218,785
Messages
6,144,492
Members
450,549
Latest member
desperato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top