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