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" wrote in message
...
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