Cell References inside a LINK

[karaflas01]

An other quick tip... i have a link like

c:\Report FY09\[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4

is it possible inside this link to put a variable reference? for example to have a cell in my excel which in this case would be
Report FY09 and if i change it to Repot FY08 the link would be

c:\Report FY08\[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4

or in another case if i have the name of the sheet like

='Report FY09'!D4
to do it
='Report FY08'!D4

or even the excel file
c:\Report FY08\[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4
to do it
c:\Report FY08\[PPV REVENUES FY 08 - Actual.xls]PPV Actual'!$C$4:$BB$4


Thanks again guys...

[sweep]

Hi,

If your directory is stored in A1, then

=INDIRECT("c:\"&A1&"\[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4")

[karaflas01]

I have tried that with the very simple change between sheets inside a workbook like
=sheet2!a1 to =indirect(b1&"'!A1) and in b2 i had sheet2 but in returns #REF!...

[sweep]

You would need that to read

=INDIRECT(b1&"!A1")

in essence, =INDIRECT("sheet2"&"!A1")

[karaflas01]

Ok i was putting 'before the ! how stupid of me... Thanks it works!