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 Wh...
- Oct 17, 2022
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*")
JMB17
Oct 17, 2022Bronze Contributor
Is "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\*.*
C:\Users\hrhquek\Desktop\DEBT RECOVERY\Bizfile\*.*