ODBC question
 

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

ODBC question
 

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.


---
Message posted from http://www.ExcelForum.com/