I have a macro to format a text file and I want to save it as a pdf file when formatted. I want a macro to do the opening of the text file and the saving as a pdf file. I recorded these operations but I need to know how to input code so that the file name is not specific. I want it to ask me what file to open and what the file name should be when formatting to pdf. Here is what I recorded.



Macro1 Macro
'
'
ActiveDocument.ExportAsFixedFormat OutputFileName:= _
"C:\Users\mbesspiata\Desktop\Dayton Countsheet File.pdf", ExportFormat:= _
wdExportFormatPDF, OpenAfterExport:=True, OptimizeFor:= _
wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _
Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _
CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _
BitmapMissingFonts:=True, UseISO19005_1:=False
ChangeFileOpenDirectory "C:\Users\mbesspiata\Desktop\"
Windows("Document1").Activate
ActiveWindow.Close
End Sub
Sub Macro2()
'
' Macro2 Macro
'
'
ChangeFileOpenDirectory "C:\Users\mbesspiata\Desktop\"
Documents.Open FileName:="Dayton Countsheet File.txt", ConfirmConversions _
:=False, ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _
WritePasswordTemplate:="", Format:=wdOpenFormatAuto, XMLTransform:="", _
Encoding:=1252
End Sub


Mike

Recorded macros are seldom good code. This one is no exception.

You could use:
in place of your code opening the file. That simply lets you pick the file.

OK. What part of my opening macro would I replace with the part you submitted?

Mike

You could replace the entire macro or everything except the first line.
This opens the FileOpen dialog.