Thank you, NoSparks!
I’d thought that selection change as a worksheet function and I was looking for a cell function . . . so skipped over it. Following your suggestion, I’ve now got the selection change working properly: When I select a cell it assigns the cell’s value to a variable. That’s a great step forward.
I've now concatenated the value with the Word extension to get the file that I want to open:
Dim CellContents as string
CellContents = Target.Value
DocumentID = CellContents & “.docx”
If, as in my example, the cell contains “Gardening-0017”, that concatenation would yield “Gardening-0017.docx”.
What Excel command do I look at to open that Word document?
Very respectfully,
Larry
|