Hi guys,

I've spent the best part of the day tinkering with this, but just can't quite find the solution. Please, please can someone help!!

I'm trying to create a 'Document Management' spreadsheet which will essentially serve as an index of all files within the same folder. The users should be able log all files which are relevant to them, and hyper link straight from the spreadsheet to open each file.
I should probably mention at this point, that it's users will be relatively computer illiterate, therefore I need to require as little input from them as possible.

Column A will be manually inputted by the user, and will contain the file name of the relevant document, but not the extension. (i.e A1 = filename1, A2 = filename2 etc.)

The problem is that the files themselves are of different types (ie. pdf, word docs etc) therefore the formulae I came up with to automate the hyperlinks doesn't work.
To get it to function the user would also have to specify the file extension, i.e A1 = filename.doc, A2 = filename2.pdf.

I seriously doubt that they would be able to cope with this (sigh!) hence I need an alternative solution.

Can anyone advise as to whether there is some VBA which could help me achieve the same thing that I had intended with the formulae?

This is what I had put together, which produced a hyperlink in col B based on the file referred to in col A... (the 'isblank' was used to prevent errors in col B where no adjacent file had been listed in A)

=HYPERLINK(IF(ISBLANK(A2),"",LEFT(CELL("filename",B1),FIND("[",CELL("filename",B1),1)-1)),"View")

Any guidance gratefully received.

Laura