How to get Duplex printing working in Excel? - Stack Overflow

文章推薦指數： 80 %
投票人數：10人

Since the duplex option cannot be chosen by VBA directly, you can workaround this by adding the same printer twice to Windows and set the ... Resultsfromthe2022DeveloperSurveyarenowavailable Home Public Questions Tags Users Companies Collectives ExploreCollectives Teams StackOverflowforTeams –Startcollaboratingandsharingorganizationalknowledge. CreateafreeTeam WhyTeams? Teams CreatefreeTeam Collectives™onStackOverflow Findcentralized,trustedcontentandcollaboratearoundthetechnologiesyouusemost. Learnmore Teams Q&Aforwork Connectandshareknowledgewithinasinglelocationthatisstructuredandeasytosearch. Learnmore HowtogetDuplexprintingworkinginExcel? AskQuestion Asked 3years,4monthsago Modified 3years,4monthsago Viewed 2ktimes 1 I'dliketoprogramaticallyprintfrontandback(Duplex)withExcel.HowcanIdothis,whilebeingagnostictothetypeofprinterI'mprintingto(Assumingitsupportsduplexprinting) excelvbaprinting Share Follow editedFeb21,2019at7:21 Pᴇʜ 54.2k99goldbadges4646silverbadges6868bronzebadges askedFeb20,2019at17:24 SelkieSelkie 1,1771515silverbadges3131bronzebadges Addacomment  |  2Answers 2 Sortedby: Resettodefault Highestscore(default) Trending(recentvotescountmore) Datemodified(newestfirst) Datecreated(oldestfirst) 1 SincetheduplexoptioncannotbechosenbyVBAdirectly,youcanworkaroundthisbyaddingthesameprintertwicetoWindowsandsetthedefaultsettingsofthesecondprintertoduplex. PrinterA(standard)

請為這篇文章評分？

延伸文章資訊