Linking to an external referance with a variable file name?

K

Kelly

Hi group, I am using the Office 2000 package.

I am trying to find out if there is a way (without using
VB at his point) to create a formula that will allow the
use of a variable file name as an external reference.

Example... If I want cell A1 to contain data from C1 of an
external workbook 1 if cell b1=1 and if b1<>1 then I want
it to get data from workbook 2.

I tried several things including this but so far I can not
get Excel to allow a variable as a file name link?...

This is one of the things I tried....

='[workbook&"variable"&.xls]Sheet1'!C1

Where variable is the cell name that contains either a 1
or a 2.

It appears everything between the [ and ] it is taking
literally??
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Reference a workbook level named variable. 8
Best Practice for Public Variables for Column Headings 2
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
VBA for Dependents shortcut menu 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Excel - Wich Function should I use? 1
Use external file variable in formula 2

Top