ODBC question

[Jim]

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

 

[tolgag]

Hi Jim,

Try to add the button after you close the connection. If it still
doesn't work, delete DSN, add the Button, save it and create a new DSN.