1. 해당 파워포인트에서 alt+F11
2. F5
3. 매크로이름 입력 후 만들기 클릭
4. 아래 코드 복사 후 붙여넣기

-----------------------------------------------------------------------

Sub ExportNotesText()

    Dim oSlides As Slides
    Dim oSl As Slide
    Dim oSh As Shape
    Dim strNotesText As String
    Dim strFileName As String
    Dim intFileNum As Integer
    Dim lngReturn As Long

    ' Get a filename to store the collected text
    strFileName = InputBox("Enter the full path and name of file to extract notes text to", "Output file?")

    ' did user cancel?
    If strFileName = "" Then
        Exit Sub
    End If

    ' is the path valid?  crude but effective test:  try to create the file.
    intFileNum = FreeFile()
    On Error Resume Next
    Open strFileName For Output As intFileNum
    If Err.Number <> 0 Then     ' we have a problem
        MsgBox "Couldn't create the file: " & strFileName & vbCrLf _
            & "Please try again."
        Exit Sub
    End If
    Close #intFileNum  ' temporarily

    ' Get the notes text
    Set oSlides = ActivePresentation.Slides
    For Each oSl In oSlides
        For Each oSh In oSl.NotesPage.Shapes
        If oSh.PlaceholderFormat.Type = ppPlaceholderBody Then
            If oSh.HasTextFrame Then
                If oSh.TextFrame.HasText Then
                    strNotesText = strNotesText & "Slide: " & CStr(oSl.SlideIndex) & vbCrLf _
                    & oSh.TextFrame.TextRange.Text & vbCrLf & vbCrLf
                End If
            End If
        End If
        Next oSh
    Next oSl

    ' now write the text to file
    Open strFileName For Output As intFileNum
    Print #intFileNum, strNotesText
    Close #intFileNum

    ' show what we've done
    lngReturn = Shell("NOTEPAD.EXE " & strFileName, vbNormalFocus)

End Sub
----------------------------------------------------------------------------------------------------------------
5.F5
6.TEXT파일명 입력 후 확인


출처 : http://powerpoint.pe.kr/60135399205


왜이리 이런 일이 많이 발생하냐....ㅠ.ㅠ

DELETE FROM table
 WHERE ROWID IN
             (SELECT RID FROM
                           (SELECT ROWID RID,ROW_NUMBER()
                                         OVER(PARTITION BY key1,key2.... ORDER BY ROWID) RN
                                FROM table
                           )
                WHERE RN<>1
             );


자원 도둑 잡기.

+ Recent posts