+ Reply to Thread
Results 1 to 3 of 3

Consolidate multiple PDFs into a single one using VBA

  1. #1
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Consolidate multiple PDFs into a single one using VBA

    Hi,

    I use the following piece of code that consolidates multiple pdf files named No.1,No.2,etc into a single file. If I am using the path of the workbook it works just fine, but if I'm adding a specific filepath to save it there and take the files as well, it returns an error on the line in red and I can't figure out why.
    Hopefully, someone has an idea. I have the Acrobat DC and I run a repair as well to clean the dll files.

    Thanks

    Please Login or Register  to view this content.
    Last edited by PaulM100; 07-18-2019 at 11:09 AM.
    Click the * to say thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,757

    Re: Consolidate multiple PDFs into a single one using VBA

    What error do you get?

    It appears that this error may be caused by having an instance of Acrobat Reader and Acrobat DC installed on the same machine. Does that describe your environment?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Consolidate multiple PDFs into a single one using VBA

    I actually found out the issue in here. My Adobe licence expired, stupid me. It turned the Acrobat into a Reader more or less. Fixed. But thank you 6StringJazzer

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consolidate fields from multiple sheets into a single summary
    By ezzy85 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2016, 04:51 AM
  2. [SOLVED] Consolidate Multiple Columns into Single Column
    By AllanTheCowboy in forum Excel General
    Replies: 17
    Last Post: 08-02-2015, 06:30 PM
  3. [SOLVED] Consolidate cells with multiple names into a single column with one name per cell
    By rbtx70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2013, 12:16 PM
  4. [SOLVED] Single product with multiple variations in multiple rows need to consolidate to single row
    By 65monroe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2013, 01:42 AM
  5. consolidate data from multiple workbooks to a single worksheet
    By vbadummy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2010, 02:42 PM
  6. Consolidate multiple workbooks into a single worksheet
    By Krista in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2006, 12:10 PM
  7. Replies: 0
    Last Post: 04-24-2006, 08:20 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1