Search results for query: *

Hi, I want to automate and do it in VBA/macro. Also I want to copy to a new file. Any idea?

Hi, I want to copy an active Excel worksheet to another new Excel file, continue to work in the new file (e.g. using Sub codeContinue() which contains the code for work), close the new file, switch back to the original Excel worksheet as the active worksheet. How to do that? Thanks!

I use below code and can successfully generated a merged PDF file. Some problems: (1) This will close the orginial Word template document, but generate a new Word document. How can I keep the orginial Word doc open and close the generated Word file after running the code? (2) How can I write...

Hi Skip, any example of your suggestion? Thanks!

Hi, (1) I tried to use below code to print as PDF from a Word file. I can generate the file, but the file is not a real PDF file (you may refer the attached link file). Any idea? Sub SetDefaultPrinter() Dim sCurrentPrinter As String On Cancel GoTo Cancelled: ' Get the current printer and...

Hi Skip, There are different letter templates send to customers for different purposes. The purpose is to combine all letters from different templates into 1 PDF file and send to print house to print. Single template might not cater the requirement as each template will print different number...

Hi Skip, So far I have no problem in mail merge a Word template using a data source Excel file and print all the letters of that Word template out (I can easily achieve that by recording a marco in Word and edit it via VBA). But I have no idea how to call a Word template, mail merge by...

Hi, I want to combine several Word mail merge files and save as 1 pdf file as an output. I am thinking to do it in Word macro/VBA. Basically, I have a few Word template letters, each with a data source excel file (i.e. n Word files & n Excel files). For each Word template letter, it will have...

Hi Skip, If there is code example would be great. If not, I would like to know if my idea work. In particular, I really have no idea how to achieve combining different Word templates' letters into 1 PDF file. Do you have any hints? Thanks!

Hi Skip, I'm a newbie in VBA. I know how to mail merge a Word template using a data source Excel file and print all the letters of that Word template out. But I have no idea how to (if the concept is right..) call a Word template, mail merge by calling its excel file, save the letters into a...

Hi, I want to write a VBA/macro to combine several Word mail merge files and save as 1 pdf file as an output. Basically, I have a few Word template letters, each with a data source excel file (i.e. n Word files & n Excel files). For each Word template letter, it will have several records (and...