Hi,
I have an xla file at work that I can post tomorrow - it -may -come in
handy for you (I'm not sure if the VBA project is locked or not). I
have only used it twice & believe that was created quite some time ago
but it's tidy & has error traps etc.
The difficulty I have with using it is the need to be able to identify
the library & table etc that the data is to be pulled from.
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=509025