Reference to File Name

rudevincy

Active Member
Joined
Feb 21, 2005
Messages
417
Please someone help!

I have a 2 workbooks in Book1.xlsx cell B2 it says

='C:\Libraries\Documents\[Book2.xlsx]Oct ''09'!$L$96

my thing is that I want instead of saying Oct ''09' I want it to refer to cell A1 (A! contains the name of the tab)

Also Book2.xlsx is closed and I have been told that I cannot use INDIRECT with closed workbooks..... it returns a #REF

is it possible to do this? PLEASE HELP!!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
I have been Googling and all I am finding is articles about how it does not function in Excel 2010
 
Upvote 0
Why don't you download it and try it? If it doesn't work you can always Edit Links and change the Source. That could be automated with a macro.
 
Upvote 0
Question after downloading this.... if another user wants to use the file they have to download this add in as well?
 
Upvote 0
In versions of Excel prior to Excel 2007 it's possible to include the Add-In in a workbook. Currently that feature isn't available in Excel 2007 and above. So the user will need to install the Add-In.
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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