ODBC question

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
Back
Top