I have a Word macro that creates a final document from a tab delimited file, which has been exported from Filemaker. Towards the end, I now want to be able to pause the macro so I can make some final adustments to the document and then Print/Save it as a PDF file to get it ready to upload to our website.
1) What is the code to pause a macro. I looked it up in macro help and couldn't find it.
2) How do you cause the Print command below that is saving the file as a pdf to save it automatically instead of the dialogue box coming up? Also, the Word macro does not recognize that the PDF dialogue SaveAs box has come up and continues running commands. If I can't get it to save automatically, I defintely don't want the macro to continue while I am dealing with the PDF SaveAs dialog box.
3) Can you insert a code into the PDF Save as box to tell it the name of the file to SaveAs? I couldn't but at least I did a workaround in saving the Word file first and the PDF SaveAs just use that name as its suggested file SaveAs name. Thank you.
' "wr_setup_r" & MyValue & ".doc"
ActivePrinter = "CutePDF Writer"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _