Dynamic Hyperlinks - Changing Folders and Filename
 

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\OpsPl an\[1106JudgementPaperLinksv003.xls]Gas FI!A1
11 Hyperlink \\manches-user1\Common\FINANCE\Forecasting\FY2006\1106\OpsPl an\[1106JudgementPaperLinksv003.xls]Gas FI!A1
D6 formula is =TEXT(C6-2000,"0#")
D7 Formula is =TEXT(C7,"0#")

Regards