Re: morefunc help

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Harlan Grove (hrlngrv_at_aol.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 19:34:27 GMT

"=?Utf-8?B?SkM=?=" wrote...
>Still having a little trouble with indirect.ext
..
>I am trying to get to summary! in log040525.xls (yymmdd) that is located in
>the dir c:\\reports\data052004 (mmyyyy)
>This is what I am using and it doesnt work

>="indirect.ext("C:\\reports\data" & text(a28,"mmyyyy")"\[log" &
>text(a28,"yymmdd")"]summary'!u7")"

Is the entire formula really within double quotes? Or is your formula

=INDIRECT.EXT("C:\\reports\data" & TEXT(A28,"mmyyyy") & "\[log" &
TEXT(A28,"yymmdd") & "]summary'!u7")

?

Note that as you wrote it above, your formula is either a syntax error at
'C:\\', where it'd be garbage after the quoted string "indirect.ext(", or if you
really don't have the entire formula inside double quotes, it's a syntax error
at "\[log", where you have a double quoted string immediately following a
function call without an & operator to concatenate them.

You have an OS error in your path. "C:\\" is invalid. It should be "C:\".
Windows supports double backslashes only at the beginning of UNC pathnames to
indicate the network device name. 

--
To top-post is human, to bottom-post and snip is sublime.
Quantcast