Create external link to another workbook cell programmatically

B

BW

Hello,

WHat is the syntax for creating an external link to a cell in another
workbook where the extternal workbook name is entered in another cell.

For example, if user enters the name of the other workbook into cell
A1='[Portfolios.xls]Sheet1'!, i want to put into cell C1 of another workbook
the value of the contents of the cell B10 in the user-specified workbook but
i want to get the data by referencing the name of the workbook the user
entered in cell A1, instead of referencing the workbook name explicitly.

Thanks for your help.
 

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

VBA code for pasting links -- modifying RDB code for summary workbook 11
Arrays and scattered cell values or another way? 16
Pasting a cell into bookmarked table from excel vba 1
How to create absolute link to cell in another workbook (Excel 2003) 1
Copy cell value from one worksheet to matching worksheet in another workbook 4
Cell values to an array, then array transpose to another workbook 8
How to create absolue path link to another workbook (Excel 2003) 1
Insert a link to a pdf file 1

Top