Excel sheet printing script
Excel sheet printing script
- Subject: Excel sheet printing script
- From: Edquist Jean-Marie via AppleScript-Users <email@hidden>
- Date: Sun, 16 Feb 2020 15:40:22 +0100
Hello,
I made a small set of excel sheets and scripts to manage the ticket office for
shows of a small association and print the tickets on a small STAR printer.
The ticket to be printed is on an Excel sheet on which the printer format and
paper size are set.
The printing script only sends the “print” function without any settings
(repeated twice to have two tickets). It therefore uses the print setting saved
with the sheet.
———————————————————
tell application "Microsoft Excel"
tell worksheet "Liste" of active workbook
print
end tell
display dialog "Imprimer le second billet ?"
tell worksheet "Liste" of active workbook
print
end tell
end tell
———————————————————
Everything worked perfectly until an OSX update which resulted in an Excel
update.
With this new version of Excel, it seems that in the layout dialog, the choice
"Options ..." which made it possible to choose the format for the printer and
the paper size no longer exists.
So my script prints in A4 format on a small receipt, so it's tiny and illegible.
Can we indicate in the script the choice of printer and format?
And if so, what is the syntax to use?
Thank you for your advice.
Regards,
Jean-Marie Edquist
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden