Hi Ger Plante
Thanks for that. The message box shows the file name but not the path name. Does that mean there's something wrong with the path?
I actually already had a message box and that one will show the entire path:
MsgBox sh1.[B5].Value & "\Meetings\Kick-Off Meeting Minutes - " & sh1.[B1].Value & ".pdf"
The results looks okay to me. I have to admit it's not how I would contruct a file name but I'm working with somebody else's data and can't change it.
Also, my file is on a shared drive. Does that matter in any way?