Thread: Trying to access different files depening on a variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Priorsyeat
 
Posts: n/a
Default Trying to access different files depening on a variable
I am trying to access other excel files depending on a variable in my current
worksheet
ie ='["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36 such that when q5 is 6 then
the expression will be
='[Plan 2005 2006.xls]Main'!P36
Reply With QuoteReply With Quote