'Alias' for file name.....

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" <[email protected]> wrote in message
news:[email protected]...
> 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....

Another option...

Copy that somefilenamethatistoolong.xls to a nice location and call it log.xls.

Use that in your formula.

Whenever the somefilenamethatistoolong.xls gets updated, you will have to
remember to copy that workbook again.



billsc wrote:
>
> 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....

--

Dave Peterson

LOL. De Bono like!


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Another option...
>
> Copy that somefilenamethatistoolong.xls to a nice location and call it
log.xls.
>
> Use that in your formula.
>
> Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> remember to copy that workbook again.
>
>
>
> billsc wrote:
> >
> > 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....
>
> --
>
> Dave Peterson

I expected some .vbs code that would copy the file, then start excel and open
that workbook so that it becomes a single click operation!

Bob Phillips wrote:
>
> LOL. De Bono like!
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Another option...
> >
> > Copy that somefilenamethatistoolong.xls to a nice location and call it
> log.xls.
> >
> > Use that in your formula.
> >
> > Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> > remember to copy that workbook again.
> >
> >
> >
> > billsc wrote:
> > >
> > > 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....
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

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" <[email protected]> wrote in message
news:[email protected]...
> 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....

Another option...

Copy that somefilenamethatistoolong.xls to a nice location and call it log.xls.

Use that in your formula.

Whenever the somefilenamethatistoolong.xls gets updated, you will have to
remember to copy that workbook again.



billsc wrote:
>
> 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....

--

Dave Peterson

LOL. De Bono like!


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Another option...
>
> Copy that somefilenamethatistoolong.xls to a nice location and call it
log.xls.
>
> Use that in your formula.
>
> Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> remember to copy that workbook again.
>
>
>
> billsc wrote:
> >
> > 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....
>
> --
>
> Dave Peterson

I expected some .vbs code that would copy the file, then start excel and open
that workbook so that it becomes a single click operation!

Bob Phillips wrote:
>
> LOL. De Bono like!
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Another option...
> >
> > Copy that somefilenamethatistoolong.xls to a nice location and call it
> log.xls.
> >
> > Use that in your formula.
> >
> > Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> > remember to copy that workbook again.
> >
> >
> >
> > billsc wrote:
> > >
> > > 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....
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

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....

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" <[email protected]> wrote in message
news:[email protected]...
> 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....

Another option...

Copy that somefilenamethatistoolong.xls to a nice location and call it log.xls.

Use that in your formula.

Whenever the somefilenamethatistoolong.xls gets updated, you will have to
remember to copy that workbook again.



billsc wrote:
>
> 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....

--

Dave Peterson

LOL. De Bono like!


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Another option...
>
> Copy that somefilenamethatistoolong.xls to a nice location and call it
log.xls.
>
> Use that in your formula.
>
> Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> remember to copy that workbook again.
>
>
>
> billsc wrote:
> >
> > 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....
>
> --
>
> Dave Peterson

I expected some .vbs code that would copy the file, then start excel and open
that workbook so that it becomes a single click operation!

Bob Phillips wrote:
>
> LOL. De Bono like!
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Another option...
> >
> > Copy that somefilenamethatistoolong.xls to a nice location and call it
> log.xls.
> >
> > Use that in your formula.
> >
> > Whenever the somefilenamethatistoolong.xls gets updated, you will have to
> > remember to copy that workbook again.
> >
> >
> >
> > billsc wrote:
> > >
> > > 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....
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson