Thanks Cindy.

The only issue is that the excel file is a shared file and it seems as
though using ODBC prevents others from accessing the Excel file!

DDE allows this.

I have heard of others having the same problem. Wonder if Microsoft
have got a solution to the DDE problem.

Thanks again!


--
Ohmes
------------------------------------------------------------------------
Ohmes's Profile: http://www.officehelp.in/member.php?userid=195
View this thread: http://www.officehelp.in/showthread.php?t=684199
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.php