Reference a filename in VBA for a workbook

[AndyEd]

I'm coming a bit unstuck. The following line of code provides the email address of the recipient, taken from Cell C7. It is my understanding that the full Workbooks().WorkSheets() references should be used rather than ActiveWorkbook, especially where the user may have multiple workbooks open simultaneously.

I want to substitute the ActiveWorkbook for the specific name of the Workbook in which this code is being called, although I would welcome any comment as to whether there is a need, as the user is going to be in this workbook in order to execute the code...

olItem.To = ActiveWorkbook.Worksheets("Memo").Range("C7")

Hopefully that makes sense...

 

[rlv01]

You can use ThisWorkbook, e.g:

olItem.To = ThisWorkbook.Worksheets("Memo").Range("C7")

 

[AndyEd]

Thank you.