Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2017, 08:27 PM
gmayor's Avatar
gmayor gmayor 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
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default


It looks like you are using late binding to Word in which case you need to use the numeric equivalents of all the Word specific commands e.g.
Code:
Private Sub CommandButton1_Click()
Dim MSWord As Object
Dim Datei As String
Dim pdfName As String
    Set MSWord = CreateObject("Word.Application")
    MSWord.Visible = True

    Datei = "D:\WordTest.doc"
    pdfName = "D:\WordTest.pdf"

    MSWord.Documents.Add
    With MSWord.Selection
        .Font.Name = "Helvetica"
        .Font.Size = 20
        .Font.Color = 255
        .Font.Bold = True
        .Font.Italic = True
        .TypeText Text:="Text"
        .TypeParagraph
    End With

    MSWord.ActiveDocument.SaveAs Datei

    MSWord.ActiveDocument.ExportAsFixedFormat _
            OutputFileName:=pdfName, _
            ExportFormat:=17, _
            OpenAfterExport:=False, _
            OptimizeFor:=0, _
            Range:=0, _
            Item:=0, _
            IncludeDocProps:=False, _
            KeepIRM:=True, _
            CreateBookmarks:=0, _
            DocStructureTags:=True, _
            BitmapMissingFonts:=True, _
            UseISO19005_1:=False

    MSWord.ActiveDocument.Close
    MSWord.Quit
    Set MSWord = Nothing

End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 05-01-2017, 01:46 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 again,

your reply was very helpful.

It's working out very nicely now.

...
Reply With Quote
Reply

Thread Tools
Display Modes


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 03:32 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