Thanks for that.

Maybe I?ve been looking at it from the wrong side.

Would it be easier to have Word get the name and file path of the open Excel Spreadsheet or have Excel ?pass? the name and file path to Word?

I thought that seeing as I have a function already in Excel to save the spreadsheet to specific name, the variable is already there and I just need Word to know what it is?.

So I guess that what I want is for Excel to pass Word a variable that Word can then use (its going to be the source file for a mail. Is that easy to do or straight forward?

Cheers

Trubble