Excel File Reference

G

GMR18769

New Member
Joined
May 30, 2008
Messages
7
Ok so thanks in advance I dont even know if this is possible I am trying to use a string of numbers in a cell to reference another excel file

kind of like this
='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25

but with the ability to change the file name without having to reference file everytime its is changed if that makes sense.

so heres the what I need

book 1
cell
a1=704241 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[704241.xls]Sheet1'!$B$25


but then i change it to
a1=802123 ='\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[802123.xls]Sheet1'!$B$25

and it is updated with the file.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Maybe you are trying to do this, but the file you are referencing has to be open:

=indirect("'\\pgiserver\General Shared Folder\MARINE FENDERS FILES\PROJECTS\[" & A1 & ".xls]Sheet1'!$B$2")

If you want to be able to access a closed file you would need to use indirect.ext() function which you can get from the morefunc free add-in at this site:

http://xcell05.free.fr/morefunc/english/

Hope that helps.
 
Upvote 0
Not sure what you mean? This shouldn't matter what operating system you are on?
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Automate data pull from one file to another
Replies
1
Views
188
John_w
J
J
  • Question
VBA Script - Can't figure out one error...
2
Replies
15
Views
236
Peter_SSs
Peter_SSs
P
  • Solved
VBA to open file using Cell for the path
Replies
4
Views
581
Peter Davison
P
J
  • Solved
VBA Project (Automatic Update) and Macro reference with file name change
Replies
8
Views
310
JDSOuth49
J
SamarthSalunkhe
  • Solved
Copy Excel From Zip Folder
Replies
9
Views
223
Domenic
D

Forum statistics

Threads
1,214,911
Messages
6,122,199
Members
449,072
Latest member
DW Draft

Share this page

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