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