+ Reply to Thread
Results 1 to 2 of 2

Combine 2 PDF files into one with pages in specific order

  1. 08-11-2022, 07:00 PM #1
    mikey3580
    mikey3580 is offline
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    Combine 2 PDF files into one with pages in specific order

    Hello,

    Any thoughts on how to combine two PDF files using VBA with the same number of pages into one PDF with pages in a specific order and save it
    This macro will be run with a different number of pages in the PDFs for each month for example

    "File1.pdf" contains 19 pages
    "File2.pdf" contains 19 pages

    (19 pages is just an example as one month could have 19 pages while another month could have 33 pages)

    so final pdf output will be

    New pdf file page 1 - "File1.pdf" - page 1
    New pdf file page 2 - "File2.pdf" - page 1
    New pdf file page 3 - "File1.pdf" - page 2
    New pdf file page 4 - "File2.pdf" - page 2
    New pdf file page 5 - "File1.pdf" - page 3
    New pdf file page 6 - "File2.pdf" - page 3
    New pdf file page 7 - "File1.pdf" - page 4
    New pdf file page 8 - "File2.pdf" - page 4
    ..........
    New pdf file page 37 - "File1.pdf" - page 19
    New pdf file page 38 - "File2.pdf" - page 19

    Thanks for any assistance
    Reply With QuoteRegister To Reply
  2. 08-11-2022, 08:40 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Combine 2 PDF files into one with pages in specific order

    This is not a native capability of Excel or VBA. Normally you need an app that can do PDF editing. If you have Adobe Acrobat Professional then there is a VBA-callable library that might allow you do this.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Print PDF files in a specific order using shell
    By DJohnny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2022, 06:29 AM
  2. Need vba code to print specific pages or all pages in a multipage UserForm
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2020, 08:13 PM
  3. [SOLVED] print pages in specific order in vba macro
    By pongmeister in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 12:33 PM
  4. PPT pages as separate files with files names from Excel
    By Amarjeet Singh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2015, 05:42 AM
  5. VBA to put multiple PDF files in specific order
    By Mr. Noob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2015, 10:32 AM
  6. [SOLVED] Query Multiple Web Pages> Sort For Specific Criteria > Save Lists of Sort in txt files
    By Tlandress in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-15-2013, 12:09 AM
  7. macro to open files in specific order
    By PatrickPerth in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1