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
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