morefunc help

[Guest]

H
Im trying to use the indirect.ext function from longre's morefunc.xll. I need to combine this with a normal indirect reference. In indirect.ext reference I place "C:\\Mypath\more_of_my-path indirect(a1)\[indirect(a1).xls]sheet1'!x2. What is proper syntax for the built-in indirect references
Thank
J

 

[Frank Kabel]

Hi
try
=INDIRECT.EXT("'C:\Mypath\more_of_my-path\[" & A1 & ".xls]sheet1'!X2")

--
Regards
Frank Kabel
Frankfurt, Germany

Hi
Im trying to use the indirect.ext function from longre's

morefunc.xll. I need to combine this with a normal indirect reference.
In indirect.ext reference I place "C:\\Mypath\more_of_my-path
indirect(a1)\[indirect(a1).xls]sheet1'!x2. What is proper syntax for
the built-in indirect references?

 

[Peo Sjoblom]

Open the other workbook and make sure it works using indirect, then replace
it with
the UDF and finally close the workbook

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Hi
Im trying to use the indirect.ext function from longre's morefunc.xll. I

need to combine this with a normal indirect reference. In indirect.ext
reference I place "C:\\Mypath\more_of_my-path
indirect(a1)\[indirect(a1).xls]sheet1'!x2. What is proper syntax for the
built-in indirect references?

 

[Guest]

Looks like that will work----Another question---now that I have loaded Morefunc, When I copy from one work book and try to paste special it seems as though something has changed----values only brings values and format both etc. Any ideas
Thanks for your help!

 

[Frank Kabel]

Hi
don't think Morefunc will affect this

--
Regards
Frank Kabel
Frankfurt, Germany

Looks like that will work----Another question---now that I have

loaded Morefunc, When I copy from one work book and try to paste
special it seems as though something has changed----values only brings
values and format both etc. Any ideas?

 

[Frank Kabel]

Hi
just output the string within the INDIRECT.EXT formula and check if
this is a correct reference

--
Regards
Frank Kabel
Frankfurt, Germany

Still having a little trouble with indirect.ext
A1 = dd/mm/yyyy
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")"
What have I messed up this time
Thanks!

 

[Guest]

It appears to be correct. My understanding is that the referenced file does not have to be open, is that correct
Thanks

 

[Daniel.M]

Hi,

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

Regards,

Daniel M.

 

[Harlan Grove]

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.

 

[Daniel.M]

Also,

C:\\ should be 'C:\

because you already have a closing ' (just before the u7):

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

Regards,

Daniel M.

 

[Frank Kabel]

Hi
this is correct. See Daniel's and Harlan's answer for correcting your
formula

--
Regards
Frank Kabel
Frankfurt, Germany

It appears to be correct. My understanding is that the referenced

file does not have to be open, is that correct?

 

[Harlan Grove]

...
...

Question....If I enter =C:\reports\data052004\[log040523]summary'!u7 in the
cell shouldnt that return the value Im looking for? If so, something still
isnt right cuz it doesnt.

Is your file named log040523 or log040523.xls? If the latter, your formula above
is missing the '.xls' at the end of the filename.

 

[Daniel.M]

Hi JC,

Question....If I enter =C:\reports\data052004\[log040523]summary'!u7 in
the cell shouldnt that return the value Im looking for?
If so, something still isnt right cuz it doesnt.

='C:\reports\data052004\[log040523]summary'!u7

should do it. Please note the first character: '

See my previous response.

Regards,

Daniel M.