Hi all,

I'm looking to develop a macro which would enable me to open a Word file based on the contents of a specific cell. The cell contents will be dynamic based on other factors within the excel sheet, and contains the full filepath of the file I am looking to open.

It is essentially a Hyperlink request, but as I am getting an error message relating to an OLE action (which I have established a code to disable) when I use the hyperlink route, I'm looking to go the VBA route to fulfil this request.

Does anyone have any advice for me in this regard? Any help as always gratefully received.

Thank you.