Right, I created a wrapper procedure to call the DB function so I don't
need to capture the return value (may add this later if someone can
help me out).

The only problem I have left now is that after executing the procedure
and fetching the data into the worksheet I lose focus from Excel
completely and have to manually select it from the Windows toolbar -
bizarre??! any ideas?

Thanks.


--
scos00
------------------------------------------------------------------------
scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805