Link9's printing FAQ

[Jonax]

See faq216-738
Hi there,
as I have very lowtech users, I'd like to know if there was a way to automate the last step (pasting into Excell) as well. Maybe by putting something in the load event of the sheet?

Any ideas?

TIA

Jonax

 

[link9]

Try putting this code into the open event for your workbook, but be advised your users will get the "This workbook contains macros" message, and will have to enable them to get it to work.

Range("A1&quot.Select
ActiveSheet.Paste

 

[Jonax]

Thx m8 ;-)