+ Reply to Thread
Results 1 to 10 of 10

Merging 2 PDF's VBA

  1. 04-20-2016, 05:23 PM #1
    JPSIMMON
    JPSIMMON is offline
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Merging 2 PDF's VBA

    Hi guys, trying to get this code to work. I have 2 PDF's I want to merge into 1 PDF, then save this "Merged PDF" to a separate location. Keep getting user defined-type not defined error. 

    Please Login or Register  to view this content.
    Anyone know how to fix this?
    Thanks
    Reply With QuoteRegister To Reply
  2. 04-20-2016, 05:29 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging 2 PDF's VBA

    Did you set a reference to Acrobat?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 04-20-2016, 05:35 PM #3
    JPSIMMON
    JPSIMMON is offline
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Re: Merging 2 PDF's VBA

    Thx shg, yeah I have Acrobat checked off
    Reply With QuoteRegister To Reply
  4. 04-20-2016, 05:38 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging 2 PDF's VBA

    So what line generates the error? It compiles fine for me, though I would commend the practice of declaring your variables.
    Reply With QuoteRegister To Reply
  5. 04-20-2016, 05:53 PM #5
    JPSIMMON
    JPSIMMON is offline
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Re: Merging 2 PDF's VBA

    I am getting "ActiveX component can't create object" on this line: 
    Please Login or Register  to view this content.
    In reference to this:
    Please Login or Register  to view this content.
    I have a fairly elementary understanding of VBA.
    Reply With QuoteRegister To Reply
  6. 04-20-2016, 06:13 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging 2 PDF's VBA

    What happened to

    Keep getting user defined-type not defined error.
    ?
    Reply With QuoteRegister To Reply
  7. 04-20-2016, 06:22 PM #7
    JPSIMMON
    JPSIMMON is offline
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Re: Merging 2 PDF's VBA

    I set my references after and stopped getting the user def-type not defined error.
    Now I am getting ActiveX component can't create object
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 04-20-2016, 06:28 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging 2 PDF's VBA

    I set my references after and stopped getting the user def-type not defined error.
    Please acknowledge when you've changed something and the ball is moving downfield -- is that reasonable?

    I have near zero experience automating acrobat, but why not

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 04-20-2016, 06:28 PM #9
    JPSIMMON
    JPSIMMON is offline
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Re: Merging 2 PDF's VBA

    SHg I think I found the fix in the lines:
    Please Login or Register  to view this content.
    changed them to:
    Please Login or Register  to view this content.
    Thanks for the help
    Reply With QuoteRegister To Reply
  10. 04-20-2016, 06:39 PM #10
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Merging 2 PDF's VBA

    You're welcome.
    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. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  2. Merging cells/merging cell content.
    By rhintintin in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 10:42 AM
  3. [SOLVED] When merging information not merging correctly
    By Bridgett in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-09-2005, 06:15 PM
  4. Sorting, Merging, and Re-merging
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Sorting, Merging, and Re-merging
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] Sorting, Merging, and Re-merging
    By Abi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Sorting, Merging, and Re-merging
    By Abi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. [SOLVED] Sorting, Merging, and Re-merging
    By Abi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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