...in Access-to-Lotus Notes automation.

I have no problems using Access to select Snapshot
of PDF files, DBF files, other objects from the C: or
Server Drives...and Embed (attach) them as part
of a Lotus Note.

I want to use an Excel File on the Server (in this scenario,
always the same filename)..IE..
"R:\Bobby\TheData.xls", but I do NOT want to attach
the entire File...ONLY a Worksheet from that File.

How would that be coded in VBA? And would it be
like a spreadsheet? If so, that's OK, because Original
Data would not be affected.

I'd prefer...IF I could code VBA, like done manually, a
selected Worksheet, and save it (and attach) as a
Microsoft Office Document Image Viewer file.

TIA - Bob