VBA User form flie link

[Endeavouring]

Hi
Is it possible to create a link within a user form to a specific worksheet in another workbook, checking that the workbook isn't already open. If it is then opening the link and if not open the workbook at the relevant sheet.
The workbook I wish to open is named history.xls and a typical sheet would be named "data 2000".

Many thanks for any assistance as I'm fairly much a newbie.

 

[Tinbendr]

Is it possible to create a link within a user form...

A hyperlink, no, but you can add code under a command button, for instance, to fetch data from that workbook. There are numerous ways to activate it, but you're going to have to tell us more about the userform.

Can you be a bit more specific about the data you want to retrieve?

(Remember, vague questions get vague answers.)

 

[Endeavouring]

For reference, it is possible to do a hyperlink.
I wasn't after a hyperlink, I just wanted to open a specific file at a specific sheet (now solved)

Thanks for your response though