Using OpenFile function

I'm hoping to avoid using an OpenDialog class as I'd like to be able to read in from my database the link to a file and just click on a button and the correct program will open according to the file extension.

I've experimented with the OpenFile function , but this requires the 'OpenWith' string to be hard coded. The only way around that I can see is to read in the file link, determine the file extension and then via some case statements 'plug in' the correct program string to open the document etc.

I haven't tried it yet as I've only just spotted it, but now I'm wondering if playing with ParamStr() would do the trick?