Hyperlink with partial name

I created a hyperlink that looks like:

=HYPERLINK("S:\Data\ManEng\BOS\MFGENG\"&J20&"_Doc\"&C20&"*.xls")

Where J20 is the user input name of the file, and C20 is the user input partial name of the file. Adding the asterix in another case would allow for any text between the partial name and ".xls". I was hoping that the hyperlink would work the same way, but apparently it simply looks for a file name with an asterix in it. Is there a way around this problem? Also, I would love to leave the ".xls" off the end altogether. That way the hyperlink should work for any file type.

Please respond even if you do not think this is possible, so that I know to try something else.

Thanks

I definitely think you need a visual basic macro.

Using the "wildcard" asterisk format is an operating system provided facillity
(which will return a list of ALL the files matching the wildcard construction).
I would not expect the standard excel file addressing to cope with this.

However I suspect that a VBA macro might be able to access the operating system facillities that provide this capability.

Try re-posting your query on the excel programming group.

Mark.