Results 1 to 3 of 3
  1. #1
    Mick99 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Jul 2015
    Posts
    58

    VBA Code to PDF & save Report then open PDF and save as Word.docx

    Hi all, could someone help with some VBA code to create a PDF from a Report then save the report and then open the saved PDF file and save as a Word.docx.


    Cheers Mick

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You have a PDF. There's no need for a word doc.
    Docmd.output ... AcFormatPDF...

  3. #3
    Mick99 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Jul 2015
    Posts
    58
    The need for the PDF is only to allow the correct formating of the word Doc. If I create a word doc it drops some of the formatting. If I save to PDF and then open and save the PDF to word docx than it retains all of the original formatting.

    Cheers Mick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report won't Save or Save As
    By DMJ in forum Reports
    Replies: 1
    Last Post: 02-03-2015, 05:46 PM
  2. Replies: 3
    Last Post: 10-20-2014, 03:25 PM
  3. Replies: 28
    Last Post: 05-25-2014, 04:01 PM
  4. Replies: 4
    Last Post: 09-15-2013, 07:34 PM
  5. Replies: 10
    Last Post: 06-20-2012, 09:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums