![]() |
|
#4
|
||||
|
||||
|
The following will loop through the documents in a selected folder and run my earlier code
Code:
Sub BatchProcess()
Dim strFile As String
Dim strName As String
Dim strPath As String
Dim oDoc As Document
Dim fDialog As FileDialog
Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)
With fDialog
.TITLE = "Select folder and click OK"
.AllowMultiSelect = False
.InitialView = msoFileDialogViewList
If .Show <> -1 Then
MsgBox "Cancelled By User", , "List Folder Contents"
Exit Sub
End If
strPath = fDialog.SelectedItems.Item(1)
Do Until Right(strPath, 1) = ""
strPath = strPath & ""
Loop
End With
strFile = Dir$(strPath & "*.doc")
' If the files are .txt format then change .doc in the line above to .txt
While strFile <> ""
Set oDoc = Documents.Open(strPath & strFile)
'do stuff with the document e.g. call the macro I posted earlier
AddLinks oDoc
' If the files are .txt format then add the following 2 lines
'strName = Left(oDoc.Name, InStrRev(oDoc.Name, ".")) & "docx"
'oDoc.SaveAs2 FileName:=strPath & strName, FileFormat:=12, AddToRecentFiles:=False
oDoc.Close SaveChanges:=wdSaveChanges
strFile = Dir$()
Wend
MsgBox "Processing complete"
lbl_Exit:
Set oDoc = Nothing
Exit Sub
End Sub
Code:
Sub Test() AddLinks ActiveDocument End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
| Tags |
| link hyperlink filename |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Insert variable in path name
|
bearcublandon | Word VBA | 6 | 01-03-2019 08:17 PM |
How to replace straight quotes with smart quotes in existing document
|
PABwriter | Word | 4 | 05-27-2016 03:36 PM |
| Changing dumb quotes to smart quotes | Reisende | Word | 2 | 05-02-2016 08:56 PM |
insert auto path & file name in ppt 2013
|
rideninc | PowerPoint | 1 | 01-28-2014 05:38 AM |
Changing single-quotes to double-quotes
|
Bobosmite | Word | 5 | 04-15-2013 06:40 AM |