Need a button to open an external file.

I have a Hyperlink to a file on another drive that works located in cell H12 as the results of a VLOOKUP function.

The Hyperlink address will change every time the form is used as the linked file will be different each time the form is used.

I just need the command button to open the hyperlink referenced in cell H12.

The link address in the H12 is a complete hyperlink address for the PDF file I am trying to open. And that link works when clicked on.

I don't want to click a hyperlink, I want to click on a button.

I have tried to record a macro to follow the link but the recorder does not pick up when i click on the link.

The hyperlink works when I record the macro. Afterwards I assign the Macro to a button, but the button does not open the link.

Thanks a lot, Dennis

Kev,
My previous thank you was lost in my poor internet connection.

I tried both of those and only got an error message.

Run-time error '438':

Object doesn't support this property or method

thanks again for your reply

dennis