Print from a Macro

[William Swan]

In Google Sheets, i have recorded a macro to print multiple worksheets. It appears to work, as the printer prints the data as recorded. However, only the worksheets, that I moved to, are recorded in Scripts Editor.

I come to Sheets from MS Excel, and using VBA, I can record a print macro that works in a few minutes.

Their are 5 worksheets that I want to print in the attached file:

TOURN. SIGN IN SHEET

TOURN. DATA SHEET

SCORE CARDS

SCORE SHEET

WKLY HANDICAP

How do I print these worksheets from a Google Sheets macro?

[Jonathan Butler]

By print, do you mean to have your printer physically print out those sheets? If so, I know HP supports eprinting. With that service, you can send an email to a printer with the document as an attachment and it will print the attachment. You can then use the MailApp to attach the document and send it to the printer.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/3bedf09f-9ed2-4c60-97b3-405ce19a075f%40googlegroups.com.

[Riël Notermans]

You can also generate a PDF and use the Google Cloud Print API with Google Apps Script to send a print job.

Riël Notermans

Op woensdagen vrij • Zzapps B.V. • High Tech Campus 9, 5656 AE Eindhoven • T 040 711 41 94 • E ri...@zzapps.nl • www.zzapps.nl

WIJ MAKEN HET ONDENKBARE MOGELIJK

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CA%2B89ScwMobJzpJtYcY5GWoAywshqg4j%2BMESWNGn0%2BU%3D6B4yJmg%40mail.gmail.com.

[William Swan]

Riel, Thank you for your reply. I have decided to change to MS Excel.  That way, I know for sure that I can print using their macro language VBA.  I am disappointed that it seems Google Sheets does not support that capability at this time.   Bill Swan

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAHjvmF4OuzDqyepC9d50fFOwWpw2KBeq_5Tpak4Eqdk_q4Xfhg%40mail.gmail.com.