[Solved] Macro Code for Duplex Printing
文章推薦指數: 80 %
Word VBA>Macro Code for Duplex Printing. Leftovercity 08:26 AM 01-26-2017. Hi Everyone, First time on here. I'm new to Macros but got one working that ...
MicrosoftOfficeForums
>MicrosoftWord
>WordVBA
MacroCodeforDuplexPrinting
UserName
RememberMe?
Password
Register
FAQ
Search
Today'sPosts
MarkForumsRead
ThreadTools
DisplayModes
#1
01-26-2017,08:26AM
Leftovercity
MacOSXOffice2016
Novice
JoinDate:Jan2017
Posts:3
MacroCodeforDuplexPrinting
HiEveryone,
Firsttimeonhere.I'mnewtoMacrosbutgotoneworkingthatcreatessequentialnumberingpagetopage.ButnowmyissuesisthatthedocumentIneeditforistwopagesandIneedittobeprintedtwosided(Duplex).WhenIruntheMacroitbypassestheprintersettingwindowandprintstwoindividualpages.IsthereaMacrocodeIcanaddtorunduplexprinting?
Here'smycurrentcode:
Code:
DimMessageAsString,TitleAsString,DefaultAsString,NumCopiesAsLong
DimRng1AsRange
'Setprompt.
Message="Enterthenumberofcopiesthatyouwanttoprint"
'Settitle.
Title="Print"
'Setdefault.
Default="1"
'Displaymessage,title,anddefaultvalue.
NumCopies=Val(InputBox(Message,Title,Default))
SerialNumber=System.PrivateProfileString("C:\Settings.Txt",_
"MacroSettings","SerialNumber")
IfSerialNumber=""Then
SerialNumber=1
EndIf
SetRng1=ActiveDocument.Bookmarks("SerialNumber").Range
Counter=0
WhileCounter
延伸文章資訊
- 1Excel VBA double sided printing | Forum post - STL Training
Excel VBA double sided printing. HI, How do i set a double sided printing via VBA? my default on ...
- 2How to get Duplex printing working in Excel? - Stack Overflow
Since the duplex option cannot be chosen by VBA directly, you can workaround this by adding the s...
- 3Print double sided - OzGrid Free Excel/VBA Help Forum
Print double sided · Cells.Select · Selection.RowHeight = 32 · With ActiveSheet.PageSetup ·.Print...
- 4[Solved] Macro Code for Duplex Printing
Word VBA>Macro Code for Duplex Printing. Leftovercity 08:26 AM 01-26-2017. Hi Everyone, First tim...
- 5Add Duplex command to Print Button (VBA) - Mr. Excel
I want pages 1&2, 3&4, 5&6, etc. to print both sides. I have a color printer on the network ... A...