How to set macro to open word file equal to cell contents of a specific cell

[ligerdub]

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.

[tigeravatar]

ligerdub,

Assuming the cells you want to act as hyperlinks are in column A and they only ever contain Word docs, give this a try:

Please Login or Register  to view this content.

[ligerdub]

Thanks for the response Tiger.

Do you know know do I assign this macro to an object or shape? When I look to assign macro to a button I don't have the option to select the above?

[tigeravatar]

That code is a Worksheet_SelectionChange event and should be placed in the appropriate worksheet module. So if the items are in column A of Sheet1, then the code would go in the Sheet1 module. Then just click on a cell in column A of sheet1 and that will trigger the SelectionChange event which will cause the code to be run.

If you need a stand alone macro that you can assign to a button, and the cell containing the Word doc filepath is in cell A1, give this a try:

Please Login or Register  to view this content.

[ligerdub]

Ah I see, I hadn't been clicking on the cell. That's a nice feature.

Thanks a lot for that, worked a treat, very much appreciated sir.