A look at the code would be useful to get an answer. Need the bit where
you open the spreadsheet and send the data.
Also do you have the spreadsheet used as a linbked table source in the
Access database?

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=520829