B
Bob Barnes
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
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