Thanks VoG, that`s a good step towards what I am trying to achieve. I may be pushing my luck a bit here but ideally I would like the link to go straight to the document without me having to browse, maybe a path could be set from the document to the cell possibly when writing the document or am I being a bit too ambitious here.
Thanks again VoG, I have achieved what I wanted to do by using a hyperlink in the date cell of each row. I have to use browse and set them individually. Not a lot of use if you have thousands to do per day but I issue about 3 or 4 invoices per week so it`s no hardship to set up a few hyperlinks manually.
You have helped me in the past with Excel questions and I appreciate your ongoing support. A lot of this I should have learnt for myself but it is finding the time, much easier to ask the forum. :-)
This thread is now locked and can not be replied to.