Ron de Bruin wrote:
Try this example
http://www.rondebruin.nl/copy5_3.htm

Hi, any help with the following would be really appreciated,

[quoted text clipped - 68 lines]

Many thanks

Many thanks for all responses,

Ron,

Many thanks for your speedy response, the example spreadsheet with the code
that saves the workbooks into a folder and then creates a hyperlink is really
'spot on' and is something I hadn't considered. This is really efficient and
gets me around any company email limits!,

Thanks alot

--
Message posted via http://www.officekb.com