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.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,597
Messages
5,597,089
Members
414,122
Latest member
eazyyexcel

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