Advertisement
Guest User

Untitled

a guest
Mar 14th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. Public Sub ExportFormatDocToDocX()
  2. Dim Fl As FileDialog, Fr As FileDialog, FolderName As String
  3. Dim EDoc As Document, i As Long
  4. Set Fr = Application.FileDialog(msoFileDialogFolderPicker)
  5. With Fr
  6. .Title = "Вибрати папку для збереження"
  7. .ButtonName = "Вибрати"
  8. .AllowMultiSelect = False
  9. End With
  10. Fr.Show
  11. If Fr.SelectedItems.Count = 0 Then
  12. MsgBox "Ви не вибрали папку для збереження!!!", vbCritical
  13. Exit Sub
  14. End If
  15. FolderName = Fr.SelectedItems(1)
  16. Set Fl = Application.FileDialog(msoFileDialogFilePicker)
  17. With Fl
  18. .Title = "Вибрати файли які сконвертувати"
  19. .ButtonName = "Конвертувати"
  20. .Filters.Clear
  21. .Filters.Add "Файли", "*.doc"
  22. End With
  23. Fl.Show
  24. If Fl.SelectedItems.Count = 0 Then
  25. MsgBox "Ви не вибрали файли для конвертації!!!", vbCritical
  26. Exit Sub
  27. End If
  28. For i = 1 To Fl.SelectedItems.Count
  29. Set EDoc = Documents.Open(Fl.SelectedItems(i))
  30. n = Split(EDoc.Name, ".")
  31. f = n(0) & ".docx"
  32. FolderName = FolderName & "\"
  33. EDoc.Convert
  34. ChangeFileOpenDirectory _
  35. FolderName
  36. EDoc.SaveAs f
  37. EDoc.Close
  38. Next i
  39. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement