Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2017, 04:36 PM
macropod's Avatar
macropod macropod is offline Creating a word file and then making a pdf from excel Windows 7 64bit Creating a word file and then making a pdf from excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you check which line was causing the error? Doubtless you'd get one with:
With MSWord.Selection
since MSWord in your code is the application, not the document.

And yes, the SaveAs2 method can produce PDFs. There are plenty of examples of that in these forums.

Try:
Code:
Private Sub CommandButton1_Click()
    Dim wdApp As Object, wdDoc As Object
    Const docName As String = "D:\WordTest.doc"
    Const pdfName As String = "D:\WordTest.pdf"
    Set wdApp = CreateObject("Word.Application")
    wdApp.Visible = True
    Set wdDoc = wdApp.Documents.Add
    With wdDoc
        .Font.Name = "Helvetica"
        .Font.Size = 20
        .Font.Color = wdColorRed
        .Font.Bold = True
        .Font.Italic = True
        .TypeText Text:="Text"
        .TypeParagraph
        'SaveAs2 Parameters: FileName, FileFormat, LockComments, Password, AddToRecentFiles, & _
            WritePassword, ReadOnlyRecommended, EmbedTrueTypeFonts, SaveNativePictureFormat, & _
            SaveFormsData, SaveAsAOCELetter, Encoding, InsertLineBreaks, AllowSubstitutions, & _
            LineEnding, AddBiDiMarks, CompatibilityMode
        .SaveAs2 docName, 0, , , False    '0 = wdFormatDocument
        .SaveAs2 pdfName, 17, , , False ' 17 = wdFormatPDF
        .Close False
    End With
    wdApp.Quit
    Set wdDoc = Nothing: Set wdApp = Nothing
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-01-2017, 01:42 AM
babysatch babysatch is offline Creating a word file and then making a pdf from excel Windows 10 Creating a word file and then making a pdf from excel Office 2016
Novice
Creating a word file and then making a pdf from excel
 
Join Date: Apr 2017
Posts: 6
babysatch is on a distinguished road
Default

Hi,

thank you for your reply.

Maybe I didn't express myself clearly.

What I meant is: "Is it possible that the pdf file created by Save2-Method automatically opens?"

Thank you.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a word file and then making a pdf from excel Excel does not work if any other excel file selected in any folder tonytonytony Excel 3 03-10-2016 04:18 PM
Creating a word file and then making a pdf from excel Making Venn Diagram in Excel kareemva Excel Programming 5 02-16-2016 12:10 AM
Creating a word file and then making a pdf from excel How to update source excel file with changes made to insserted excel file in OneNote winwell OneNote 1 11-03-2015 12:19 PM
sending data from UserForm of existing excel file to a new excel file saltlakebuffalo Excel Programming 0 02-13-2014 10:55 PM
Creating a word file and then making a pdf from excel how to copy some information from one excel file to another excel file tomlam Excel Programming 4 10-01-2013 03:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft