software

I am trying to access other excel files depending on a variable in my current
worksheet
ie ='[quot;Plan 200quot;amp;q5-1amp;quot; 200quot;amp;q5amp;quot;.xlsquot;]Main'!P36 such that when q5 is 6 then
the expression will be
='[Plan 2005 2006.xls]Main'!P36

=INDIRECT(quot;'[quot;Plan 200quot;amp;q5-1amp;quot; 200quot;amp;q5amp;quot;.xlsquot;]Main'!P36quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Priorsyeatquot; gt; wrote in message
...
gt; I am trying to access other excel files depending on a variable in my
current
gt; worksheet
gt; ie ='[quot;Plan 200quot;amp;q5-1amp;quot; 200quot;amp;q5amp;quot;.xlsquot;]Main'!P36 such that when q5 is 6
then
gt; the expression will be
gt; ='[Plan 2005 2006.xls]Main'!P36