Link a cell in another workbook using a file name in a cell.

M

MichaelRLanier

I have a range of file names reflected on a single worksheet. The
contents of cell A1 reads Smith.xls, B1 is Jones.xls, C1 is Brown.xls,
etc., all of which are names of current files on my C: drive. I want
to read Sheet1, cell A1 in each file. In cell A10, I need to place
the file name from A1 into the Workbook.xls section of the formula
(below), thereby creating a link. In other words, I want the
Workbook.xls section of the formula in some way to read the file name
in A1. I want to do the same in cells B10, C10, etc.

'[Workbook.xls]Sheet1'!$A$1

Is this possible? Here's to thanking you in advance.

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Naming non-contigent cells with vba 5
Change file name when saved to C drive 2
Arrays and scattered cell values or another way? 16
Dynamic links to other sheets 2
Hyperlink to cells in other workbooks keep changing 3
Need to auto-enter last updated date, only if another cell has changed 1
VBA code for pasting links -- modifying RDB code for summary workbook 11

Top