Document Image Writer, .snp & PDF

[Bob Barnes]

I've read that Snapshot and PDF Files might be the only ways to
attach an Access Report in an Email.

The last 2 days, I asked in both the Access and Excel Newsgroups
if I could select an Excel Worksheet from an Excel file, and send that
as a Snapshot file...there were NO replies.

A User showed me he can select an Excel Worksheet (manually)...I can also do
that w/ VBA...but can I use VBA to make that selected Worksheet, like he did
manually...a Microsoft Office Document Image Writer object???

TIA - Bob

 

[Arvin Meyer [MVP]]

To my knowledge, only the PDF format works for sending an Excel spreadsheet
as a report. The Snapshot format is similar to a PDF, but only for Access.
It does not work in Excel. If you simply want to send an Excel worksheet to
another Excel user, just attach the worksheet itself.

 

[Bob Barnes]

Arvin - How is a Worksheet (not the entire xls) attached via code?

TIA - Bob

 

[Arvin Meyer [MVP]]

You can copy and paste the contents of a worksheet into an email, but to do
so in code, is not easy from within Access, you may be able to get some
additional information to enable this from an Outlook newsgroup, or possibly
from an Excel group.

When you use the TransferSpreadsheet method, or the OutputTo method only a
single worksheet is created and that is the entire xls file. You can attach
that with the following code:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Bob Barnes]

Arvin - I'm using Lotus Notes and should get this to work.

Thank you - Bob

 

[Arvin Meyer [MVP]]

I know that Notes can send an Excel file as an attachment, but I've never
tried pasting the data directly into a Notes email. I no longer have any
Notes machines available, so I can't test that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Bob Barnes]

Arvin - I'll plan to test that by the end of today...there are 2 other "Hot"
Projects here today. Whoever said Access didn't have much worK?

Will post back here - thank you - Bob

 

[Bob Barnes]

Arvin - I asked this in Excel "Programming"...but NO replies...

...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
'=============
So, unless something occurs (a reply), it looks like attaching the entire
Excel file
is what I'll have to do.

Thank you - Bob

 

[Douglas J. Steele]

AFAIK, Excel works on a workbook level. You could copy the single sheet to a
new workbook and then attach that new single-sheet workbook, but there's
nothing in Excel that I'm aware of to do it automatically for you.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Arvin Meyer [MVP]]

That's correct. You can embed a worksheet in an email by copying and pasting
its contents, but you'd have to create a new workbook with the worksheet to
attach it. In order to do an attachment, you must have a file, so there is
no other way to do it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Bob Barnes]

Arvin & Doug - My Client has all kinds of Links in 5 separate Worksheets,
but wanted to attach only one Worksheet in the Lotus Note.

This must be all automated. Wonder if I can call automation code to copy
and paste
that particular Worksheet, and place it in an Excel Workbook? I know I can
take an Access Query, and TransferSpreadsheet.

Do either of you know...or should I ask the Excel "Programming" Newsgroup?

TIA - Bob

 

[Douglas J. Steele]

Yes, you can automate the copy, but I'm afraid I don't have code handy. Go
into Excel and turn on the macro recorder. Right-click on the tab for the
sheet in question and one of the options will be to copy the sheet. Copy it
to a new workbook, then look at the code that was recorded for you.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Bob Barnes]

Doug - I'll try that.

Thank you - Bob

Yes, you can automate the copy, but I'm afraid I don't have code handy. Go
into Excel and turn on the macro recorder. Right-click on the tab for the
sheet in question and one of the options will be to copy the sheet. Copy it
to a new workbook, then look at the code that was recorded for you.

 

[sakamotoyukihiro]

Arvin - I asked this in Excel "Programming"...but NO replies...

..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
'=============
So, unless something occurs (a reply), it looks like attaching the entire
Excel file
is what I'll have to do.

Thank you - Bob

 

[sakamotoyukihiro]

That's correct. You can embed a worksheet in an email by copying and
pasting its contents, but you'd have to create a new workbook with the
worksheet to attach it. In order to do an attachment, you must have a
file, so there is no other way to do it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[sakamotoyukihiro]

Arvin - I asked this in Excel "Programming"...but NO replies...

..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
'=============
So, unless something occurs (a reply), it looks like attaching the entire
Excel file
is what I'll have to do.

Thank you - Bob

 

[sakamotoyukihiro]

Arvin - I asked this in Excel "Programming"...but NO replies...

..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
'=============
So, unless something occurs (a reply), it looks like attaching the entire
Excel file
is what I'll have to do.

Thank you - Bob