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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

nick m

New Member
Joined
Sep 27, 2002
Messages
14
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
 

shammer

New Member
Joined
Feb 26, 2002
Messages
25
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!
 

shammer

New Member
Joined
Feb 26, 2002
Messages
25

ADVERTISEMENT

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?
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
In lenze's example, try adding this
"="&
just after the equal sign.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,862
Messages
5,834,036
Members
430,256
Latest member
Todor T

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
Top