Forum Discussion
hrh_dash
Oct 17, 2022Iron Contributor
Macro execute to loop all word doc files in a folder
How do i amend the code below so that the macro could select all word doc files in the folder?
There are no errors but when the code is executed line by line, the macro did not run through the Do While loop.
Dim path As String
Dim oDoc As Object
Application.ScreenUpdating = False
Application.EnableEvents = False
path = "C:\Users\hrhquek\Desktop\DEBT RECOVERY\Bizfile"
myFile = Dir(path & "*.*")
Do While myFile <> ""
Set oDoc = documents.Open(filename:=path & myFile)
Call extractdatafromwordtoexcel
Call findcopyandpaste
wordDoc.Close
myFile = Dir
Loop
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub
Appreciate the assist in advance..
Also, to be on the safe side, I'd explicitly loop through Word documents, so that you don't get an error if the folder contains another type of file:
path = "C:\Users\hrhquek\Desktop\DEBT RECOVERY\Bizfile\" myFile = Dir(path & "*.doc*")
Also, to be on the safe side, I'd explicitly loop through Word documents, so that you don't get an error if the folder contains another type of file:
path = "C:\Users\hrhquek\Desktop\DEBT RECOVERY\Bizfile\" myFile = Dir(path & "*.doc*")
- hrh_dashIron Contributor
, if i would like to add an additional file type such as docx; would the following be correct?
currently, nothing is being populated when the code is executed.
myFile = Dir(path & "*.docx*;*.doc*")
- JMB17Bronze ContributorIs "Bizfile" the name of a folder, or is it the first part of the filename(s)? If it's a folder, then you need a "\" to separate "Bizfile" and "*.*".
C:\Users\hrhquek\Desktop\DEBT RECOVERY\Bizfile\*.*