Put first paragraph as filename in a WORD MACRO VBA

Question

I am looking for a way to add the first paragraph (users name) as the Filename.pdf in a Word VBA macro. I have a module where it saves every new page as a .pdf file. Now I need every .pdf file to be unique with the users name written in the first paragraph of the page.

Sub SaveAsSeparatePDFs()
'Updated by Extendoffice 20180906
    Dim I As Long
    Dim xStr As String
    Dim xPathStr As Variant
    Dim xDictoryStr As String
    Dim xFileDlg As FileDialog
    Dim xStartPage, xEndPage As Long
    Dim xStartPageStr, xEndPageStr As String
    Set xFileDlg = Application.FileDialog(msoFileDialogFolderPicker)
    If xFileDlg.Show <> -1 Then
        MsgBox "Please chose a valid directory", vbInformation, "Kutools for Word"
        Exit Sub
    End If
    xPathStr = xFileDlg.SelectedItems(1)
    xStartPageStr = InputBox("Begin saving PDFs starting with page __? " & vbNewLine & "(ex: 1)", "Kutools for Word")
    xEndPageStr = InputBox("Save PDFs until page __?" & vbNewLine & "(ex: 7)", "Kutools for Word")
    If Not (IsNumeric(xStartPageStr) And IsNumeric(xEndPageStr)) Then
        MsgBox "The enterng start page and end page should be number format", vbInformation, "Kutools for Word"
        Exit Sub
    End If
    xStartPage = CInt(xStartPageStr)
    xEndPage = CInt(xEndPageStr)
    If xStartPage > xEndPage Then
        MsgBox "The start page number can't be larger than end page", vbInformation, "Kutools for Word"
        Exit Sub
    End If
    If xEndPage > ActiveDocument.BuiltInDocumentProperties(wdPropertyPages) Then
        xEndPage = ActiveDocument.BuiltInDocumentProperties(wdPropertyPages)
    End If
    For I = xStartPage To xEndPage
        ActiveDocument.ExportAsFixedFormat xPathStr & "Page_" & Selection.Paragraphs(1).Range.Select & I & ".pdf", _
        wdExportFormatPDF, False, wdExportOptimizeForPrint, wdExportFromTo, I, I, wdExportDocumentWithMarkup, _
        False, False, wdExportCreateHeadingBookmarks, True, False, False
    Next
End Sub

The section of Selection.Paragraphs(1).Range.Select needs to be the first paragraph of every page I am saving to pdf.

Hope you can help!

Answer 1

If I understood your question correctly you have the username as the first paragraph of each page.

That being the case I would go with something like this:

Dim rg As Range, username As String

For i = xStartPage To xEndPage

    Set rg = Activedocument.GoTo(wdGoToPage, wdGoToAbsolute, i)
    Set rg = rg.Paragraphs(1).Range
    rg.Select                                       #<= select for testing only
    username = Replace(rg.Text, vbCr, vbNullString) #<= replacing the paragraph sign at the end with nothing
    
    ActiveDocument.ExportAsFixedFormat xPathStr & "Page_" & username & i & ".pdf", _
    wdExportFormatPDF, False, wdExportOptimizeForPrint, wdExportFromTo, i, i, wdExportDocumentWithMarkup, _
    False, False, wdExportCreateHeadingBookmarks, True, False, False
Next