Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. derricklo1980

    How to copy an active Excel worksheet to another excel file?

    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!
  2. derricklo1980

    Print as a PDF file from a Mail Merge Word file

    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...
  3. derricklo1980

    combining different Mail Merge Word files and generate into 1 pdf file

    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...
  4. derricklo1980

    combining different Mail Merge Word files and generate into 1 pdf file

    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...

Part and Inventory Search

Back
Top