I'm using Access-to-Excel automation, and would like to do this...

Either manually in an Excel File, click a Button/ Worksheet that
will be copied-pasted-as-Special = text, and then saved as another
Excel File so I can run a .snp or PDF File to attach to a Lotus Note.

....or..do the above from within an Access Form module.

Any ideas? TIA - Bob

Your request is somewhat non-specific. Look here for some specific examples:
http://examples.oreilly.com/integratingea/

Regards,
Ryan--

--
RyGuy


"Bob Barnes" wrote:

I'm using Access-to-Excel automation, and would like to do this...

Either manually in an Excel File, click a Button/ Worksheet that
will be copied-pasted-as-Special = text, and then saved as another
Excel File so I can run a .snp or PDF File to attach to a Lotus Note.

...or..do the above from within an Access Form module.

Any ideas? TIA - Bob

Ryan - I'm not sure where to look..I opened the 2nd one, but there were many
other Files there.

I'd like to essentially take a Snapshot/ PDF of ONE Worksheet ONLY, and
make that an attachment to a Lotus Note.

Thank you - Bob

"ryguy7272" wrote:

Your request is somewhat non-specific. Look here for some specific examples:
http://examples.oreilly.com/integratingea/

Regards,
Ryan--

--
RyGuy


"Bob Barnes" wrote:

I'm using Access-to-Excel automation, and would like to do this...

Either manually in an Excel File, click a Button/ Worksheet that
will be copied-pasted-as-Special = text, and then saved as another
Excel File so I can run a .snp or PDF File to attach to a Lotus Note.

...or..do the above from within an Access Form module.

Any ideas? TIA - Bob