I was able to find an Access MDB file that is supposed to have some code
that will do this (and lots more), but I don't have a new enough version
of Access (I think that's the problem, my 97 version won't recognize the
file) and I don't know how else to get the VBA code out of the MDB file.
If someone has an up to date version of access and wants to send me the
code, I can send you the file if you PM me your email address.
Thanks.
--
GerbilGod7
------------------------------------------------------------------------
GerbilGod7's Profile:
http://www.excelforum.com/member.php...o&userid=13073
View this thread:
http://www.excelforum.com/showthread...hreadid=542177