Automation
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 |
Automation
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 |
Automation
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 |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com