![]() |
|
|
|
#1
|
||||
|
||||
|
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] |
|
#2
|
|||
|
|||
|
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. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel does not work if any other excel file selected in any folder
|
tonytonytony | Excel | 3 | 03-10-2016 04:18 PM |
Making Venn Diagram in Excel
|
kareemva | Excel Programming | 5 | 02-16-2016 12:10 AM |
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 |
how to copy some information from one excel file to another excel file
|
tomlam | Excel Programming | 4 | 10-01-2013 03:06 PM |