Save A Worksheet as a Snapshot File
 

I'm an Access Developer who would like to get Excel to do (either thru
automation within Access), or an Excel macro to...

I have no problems using Access to select Snapshot
or PDF files, DBF files, other objects from the C: or
Server Drives...and Embed (attach) them as part
of a 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