Sub snb()
With CreateObject("scripting.filesystemobject")
For Each fl In .GetFolder("Z:\FireSuppression\test\MSA Tracking\UnProcessed").Files
If .getextensionname(fl) = "doc" Then
With GetObject(fl)
Workbooks("MSA SCBA Tracking.xls").Sheets(1).Cells(Rows.Count, 1).End(xlUp).Offset(1).Resize(, 7) = Array(.FormFields(1).Result, .FormFields(2).Result, .FormFields(3).Result, .FormFields(4).Result, .FormFields(5).Result, .FormFields(6).Result, .FormFields(7).Result)
.Close 0
End With
Name fsFile As "Z:\FireSuppression\test\MSA Tracking\Processed\" & Dir(fl)
End if
Next
End With
End Sub
Bookmarks