I'm using a DSN to use data from one workbook in another.

Is it possible within VBA to open the workbook which is 'connected' to the
DSN.

So the DSN 'Test2' connects to c:\data\interesting.xls. I connect to this by
using the SQL.CONNECT formula. I want to add a button to the sheet that
will allow users to open the source workbook 'interesting.xls'. This is
where I'm stuck.

Any thoughts??

Regards. Jim