Re: Run one macro from another and edit filenames for PDF printing

Ignore this branch!

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Graham Mayor wrote:
Hmmmm. I've spotted another deliberate mistake. Saving back the
original document produces all the documents without the answers so
it needs the white changing back to black (or auto) again ie

The problem is undoubtedly with the section that names the files in
the temporary folder that is overly complicated. I'll have to play
around with that some more :(

Do While DocList <> ""
Documents.Open DocList
With ActiveDocument
sname = Left$(.name, (Len(.name) - 4)) & "A.doc"
.SaveAs DocDir & "Temp\" & sname
.SaveAs DocList
For Each aShape In .Shapes
If aShape.Type = msoTextBox Then
With aShape
If .TextFrame.HasText Then
.TextFrame.TextRange.Font.Color =
wdColorWhite End If
End With
End If
Next
sname = Left$(.name, (Len(.name) - 4)) & "Q.doc"
.SaveAs DocDir & "Temp\" & sname
For Each aShape In .Shapes
If aShape.Type = msoTextBox Then
With aShape
If .TextFrame.HasText Then
.TextFrame.TextRange.Font.Color =
wdColorAuto End If
End With
End If
Next
.SaveAs DocList
.Close Savechanges:=wdDoNotSaveChanges
End With
DocList = Dir$()
Loop



I am using Acrobat 8 and I have the printing preferences set up as
shown at http://www.gmayor.com/individual_merge_letters.htm


Dan B wrote:
I've managed to tweak the PDF driver setup and Acrobat doesn't always
stick now.

However, the macro seems to only convert the first word doc it finds
in the folder and then stops. Also, trying to convert with a
previous Temp folder in place seems to make Acrobat stick. Is there
a way we can delete the previous Temp folder before proceeding with
conversion?

Any ideas?

If you get things working, is there any chance you can send me a
screenshot of how you have your PDF driver setup?

Cheers,

Dan.

"Dan B" wrote:

Acrobat appears to get stuck when creating the second PDF (Q.doc).

Maybe this needs tweaking. Any ideas?

"Graham Mayor" wrote:

The following appears to work. As for the question about Word 2007,
then apart from the fact that for this particular issue the ability
to *Save* as PDF would have made things a tad simpler, I prefer to
work in 2003. Word 2007 will make your life a whole lot more
complicated than it needs to be.

The macro creates (where it doesn't already exist) a folder called
Temp as a sub folder of the folder that contains the documents. A
loop then saves the documents, running your code to reformat the
text boxes, along the way with the addition of Q to signify
questions only and A to signify questions and answers (which is
what you originally requested). Another loop then runs on the Temp
folder to print to the Adobe driver, which will create its files
wherever you have told the driver to do so.

I have had to insert a couple of extra save as processes and a
couple of ChDir commands as the macro seemed to lose track of where
it was working without them. I am sure there must be a better way,
but I can't immediately see it. Unfortunately I don't know enough
about addressing the Adobe driver directly to offer that as a
simpler alternative, but that should be possible.

Sub BatchPrint2PDF()
Dim DocList As String
Dim DocDir As String
Dim sPrinter As String
Dim aShape As Shape
Dim fDialog As FileDialog
Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)

With fDialog
.Title = "Select Folder containing the documents to be printed
to PDF and click OK"
.AllowMultiSelect = False
.InitialView = msoFileDialogViewList
If .Show <> -1 Then
MsgBox "Cancelled By User"
Exit Sub
End If
DocDir = fDialog.SelectedItems.Item(1)
If Right(DocDir, 1) <> "\" Then DocDir = DocDir + "\"
End With
On Error Resume Next
MkDir DocDir & "Temp\"

If Documents.Count > 0 Then
Documents.Close Savechanges:=wdPromptToSaveChanges
End If
DocList = Dir$(DocDir & "*.doc")
Do While DocList <> ""
Documents.Open DocList
With ActiveDocument
sname = Left$(.name, (Len(.name) - 4)) & "A.doc"
.SaveAs DocDir & "Temp\" & sname
.SaveAs DocList
For Each aShape In .Shapes
If aShape.Type = msoTextBox Then
With aShape
If .TextFrame.HasText Then
.TextFrame.TextRange.Font.Color =
wdColorWhite End If
End With
End If
Next
sname = Left$(.name, (Len(.name) - 4)) & "Q.doc"
.SaveAs DocDir & "Temp\" & sname
.SaveAs DocList
.Close Savechanges:=wdDoNotSaveChanges
End With
DocList = Dir$()
Loop

DocList = Dir$(DocDir & "Temp\*.doc")
Do While DocList <> ""
ChDir DocDir & "Temp\"
Documents.Open DocList
ActivePrinter = sPrinter
With Dialogs(wdDialogFilePrintSetup)
sPrinter = .Printer
.Printer = "Adobe PDF"
.DoNotSetAsSysDefault = True
.Execute
End With
With ActiveDocument
.PrintOut
ActivePrinter = sPrinter
.Close Savechanges:=wdDoNotSaveChanges
End With
DocList = Dir$()
Loop
End Sub

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Dan B wrote:
Thanks Graham - really appreciate it.

Would you say that Word 2007 makes life easier in terms of macro
development and general use? Maybe I should push the boss for an
upgrade.

"Graham Mayor" wrote:

I was afraid you might be using Word 2003 ;) Leave it with me for
a bit. I'll have a play around.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Dan B wrote:
The code I'm using to 'hide' the answers is actually just
adjusting the font colour of all text in text boxes (from dark
grey to white):

Sub HideAnswers()

' Find each text box and set it's font colour to white

Dim aShape As Shape

For Each aShape In ActiveDocument.Shapes
If aShape.Type = msoTextBox Then
With aShape
If .TextFrame.HasText Then
.TextFrame.TextRange.Font.Color = wdColorWhite
End If
End With
End If
Next

End Sub

To show the answers I use another macro to do the reverse
(change font colour in text boxes from white back to grey).

I'm using Word 2003 and ideally I will need the solution to work
on Word XP.

Cheers,

Dan.

"Graham Mayor" wrote:

I looked at this late yesterday and decided that it lacked an
essential bit of information that I was going to come back to
this morning.

3) Hide the answers using macro built into doc.

I think we need to know more about how the documents are hidden
in order to create a seamless process; other than that I was
working along the same lines to create a temporary folder to
catch the documents in order to allow Acrobat to create the
PDFs using the file names, but it should be possible to use the
macro to generate the file names (if I knew a bit more about
the Acrobat object model)

I also wondered at the Word version as this is altogether much
easier in Word 2007 which can *save* documents in PDF format,
thus making the naming easier and avoiding the use of the print
function altogether.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Jean-Guy Marcil wrote:
"Dan B" wrote:

Hi.

I have a series of question / answer sheets as word docs.
Each Word doc has macros to show or hide answers. My
intention is perform a batch process to all docs as follows:

1) Open doc.
2) Print to PDF (answers showing by default) using word doc
filename as PDF filename.
3) Hide the answers using macro built into doc.
4) Print a second PDF using word doc filename (but replace
the last character 'a' with 'q') as PDF filename.


Here is one way of going about it:

Declare a document object, like:
Dim docProcess As Document
Once your code has made sure that there are documents to
process, create a sub directory for the Student versions
(parentDirectory\Student)
Use the doc object to open the first doc in the list:
Set docProcess= Documents.Open(DocList)
Use the doc to do the processing:
With docProcess
.Printout
.etc
End With
Since the easiest way to gt the PDF name is to ge it from the
Word doc, I would recommend doing a Save As with the suffix
you want to the new Student subdirectory.
Run the macro in that new doc by using something like:
ProjectName.ModuleName.SubName
Create the PDF.
Close the document.
Delete this doc document.
Repeat and rinse.

This way, when you are done, you will have a sub directory
with the PDF Question documents attached to the parent
directory which will contain both the PDF and the Word Answer
sheet. This solution will require more code than I have time to
write
right now. You may try and ask specific questions with the
parts you are having problems with.

Or course, someone will drop in with a much simpler
solution... I always complicate things...


.

Relevant Pages

  • Re: Word closing down
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... emptied the Template folder (including the subfolders Document Themes ...
    (microsoft.public.word.docmanagement)
  • Re: spell check error
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... spelling errors in this document only" box | OK. ...
    (microsoft.public.word.docmanagement)
  • Re: Run one macro from another and edit filenames for PDF printing
    ... but it still sticks on the second PDF conversion. ... 'Final loop outputs all the document files in the temp folder to PDF ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.vba.general)
  • Re: Macros to add a row in a word table
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... from the cell in which the Word formula field is placed. ...
    (microsoft.public.word.vba.general)
  • Re: Word file format problems
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... If these files are genuinely in Word 97-2003 format, ...
    (microsoft.public.word.docmanagement)