Re: 'Alias' for file name.....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try this

Create a name (Insert>Name>Define ...) with a name of log and the value of
=c:\logfile\the file name.xls and then use

=INDIRECT(log&"Sheet1A1")

etc.

This only works while the othetr book is open, so you may need to do a
copy/paste values.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"billsc" <billsc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54C7F132-BABB-4C2B-AB63-ADB05E257154@xxxxxxxxxxxxxxxx
> I have a long log file where I pull only 10 of the columns and combine
data.
> This means I need to have the somefilenamethatistoolong.xls in every
formula
> and the file may change from release to release.
> I would like to put some where that "log=
> c:\logfiles\somefilenamethatistoolong.xls"
> and then use [log] in the formulas...
> How do I do this....


.

Relevant Pages

  • Re: Lookup() problem
    ... "Wayman Bell" wrote in message ... >> (remove nothere from the email address if mailing direct) ... >>> The first time I tried it seemed to pull the correct matching names and ...
    (microsoft.public.excel)
  • Re: Reversing POWER Formula
    ... > (remove nothere from the email address if mailing direct) ... >> Thanks for above responses. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Pull down menus possible in excel?
    ... (remove nothere from the email address if mailing direct) ... > I have a list of books I'm putting into a spreadsheet and I was ... > and have a pull down menu where I can list the different chapters. ...
    (microsoft.public.excel.misc)
  • Re: column to column conditional formatting wont work, need formula
    ... HTH ... (remove nothere from the email address if mailing direct) ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: File in use Dialog box
    ... (remove nothere from the email address if mailing direct) ... > When I open a file that is opened on the network by someone else it is not ... Prev by Date: ...
    (microsoft.public.excel.misc)