|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- '每页插入WORD对应段落作为备注
- With Application.FileDialog(msoFileDialogFilePicker)
- Dim vrtSelectedItem As Variant
- .Filters.Clear
- .Filters.Add "Word文件", "*.doc*"
- .AllowMultiSelect = False
- If .Show = -1 Then MyPath$ = .SelectedItems(1) Else Exit Sub
- End With
- Dim i%, j%, p%, wdApp, arr()
- Set wdApp = CreateObject("Word.Application")
- p = ActivePresentation.Slides.Count
- With wdApp.Documents.Open(MyPath)
- wdApp.Visible = False
- For i = 1 To .Paragraphs.Count
- ReDim Preserve arr(1 To i)
- arr(i) = Replace(.Paragraphs(i).Range.Text, Chr(13), "")
- Next
- .Close False
- End With
- wdApp.Quit
- Set wdApp = Nothing
- If UBound(arr) < p Then MsgBox "Word中段落总数与PPT的张数不相等,请重新调整!": Exit Sub
- For i = 1 To p
- ActivePresentation.Slides.Item(i).NotesPage.Shapes.Placeholders(2).TextFrame.TextRange.Text = arr(i)
- Next
- MsgBox "处理完成!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|