C
Cole
Hello computer gods and goddesses,
I've got a Word 2003 document that I'm trying to create a VBA macro
for simply to tell it which printer to go to, and to print Duplex 3
(vertical binder.)
I'm still in the early stages of learning the ropes. But I've been
unable to get a macro to fire off when the document gets opened by
another application, (i.e. sdOffice,) OR when a Mail Merge occurs...
My sorry attempt at coding this follows. This is in a Template
document (.dot extension.) I was hoping that when the document was
opened, it would fire off this event and do my procedure. But I'm
obviously clueless. I get no message box...
Sub Document_Open()
ActiveDocument.PageSetup.Orientation = wdOrientPortrait
ActivePrinter = "P9638" 'This is temporary to send this doc
to
'the printer near IT
MsgBox ("active printer is " & ActivePrinter)
End Sub
I've also tried: Sub Document_New() thinking it's creating a new doc
from the Template that this code is within.
Be it known, I've already sacrificed a chicken. I hope that helps at
least a bit Does anyone have a suggestion of a really good Word
VBA for Dummies - type book? (I'd like to find substantially more
comprehensive than the Dummies series, but still clear for beginners!)
Thanks for the help !!!
Cole
I've got a Word 2003 document that I'm trying to create a VBA macro
for simply to tell it which printer to go to, and to print Duplex 3
(vertical binder.)
I'm still in the early stages of learning the ropes. But I've been
unable to get a macro to fire off when the document gets opened by
another application, (i.e. sdOffice,) OR when a Mail Merge occurs...
My sorry attempt at coding this follows. This is in a Template
document (.dot extension.) I was hoping that when the document was
opened, it would fire off this event and do my procedure. But I'm
obviously clueless. I get no message box...
Sub Document_Open()
ActiveDocument.PageSetup.Orientation = wdOrientPortrait
ActivePrinter = "P9638" 'This is temporary to send this doc
to
'the printer near IT
MsgBox ("active printer is " & ActivePrinter)
End Sub
I've also tried: Sub Document_New() thinking it's creating a new doc
from the Template that this code is within.
Be it known, I've already sacrificed a chicken. I hope that helps at
least a bit Does anyone have a suggestion of a really good Word
VBA for Dummies - type book? (I'd like to find substantially more
comprehensive than the Dummies series, but still clear for beginners!)
Thanks for the help !!!
Cole