Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create external link to another workbook cell programmatically
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can not create an external link between two Excel 2007 workbooks | Excel Worksheet Functions | |||
Excel- how to create external link with autoupdate | Excel Discussion (Misc queries) | |||
Create an external reference link with embedded variable | Excel Worksheet Functions | |||
Link to external workbook | Excel Discussion (Misc queries) | |||
How can I create a link to a specific sheet from external web page | Excel Discussion (Misc queries) |