Dynamic Hyperlinks - Changing Folders and Filename

[Philip J Smith]

Hi.

I am trying to construct a variable hyperlink, which will change according
to user selection (Data Validation) in cells C6:C8.
The resulting hyperlink appears in cell C11, notes on intermediate formulae
are shown below.
The hyperlink appears blue and underlined, but when I click on it I receive
the message “Cannot Open Specified Fileâ€.

Two folder levels can vary (The folder structure is determined by policy)

Financial Year FY20YY
Month and Year MMYY

The file name varies by

Month and Year MMYY
Version Number v00#
Where # = 1 - 9

Can anyone point out where I am going wrong please?

B C D
5 Folder \\manches-user1\Common\FINANCE\Forecasting\FY
6 Year 2006 06
7 Month 11 11
8 Version 3 v003.xls]Gas FI
9 Cell A1 !A1
10 Text for
link \\manches-user1\Common\FINANCE\Forecasting\FY2006\1106\OpsPlan\[1106JudgementPaperLinksv003.xls]Gas FI!A1
11 Hyperlink \\manches-user1\Common\FINANCE\Forecasting\FY2006\1106\OpsPlan\[1106JudgementPaperLinksv003.xls]Gas FI!A1
D6 formula is =TEXT(C6-2000,"0#")
D7 Formula is =TEXT(C7,"0#")

Regards