Hi All,

I am running a macro from Excel, part of which opens a specified word document.

At the moment, the filepath for the said word document reads:

C:\Users\jeremy.watson\*****\*****\*****\*****.docm

The document exists as a shared document and therefore if sarah Jennings wants to run the macro, Jeremy.watson would need to be replaced with sarah.jennings!

I hope that makes sense... The half solution I have come up with is asking the user to enter their username into a cell - and then having the filepath refer to that cell to inform the filepath.

If the above makes any sense, could someone tell me if it is possible, and if so, what should my filepath look like if I want it to incorporate the value in cell D2 instead of having a fixed path that reads name.surname?

Thanks in advance for anyone's time!

Total Noob.