I am using Access to edit a number of word documents in a folder. I need to edit each file within the folder, save file (same name & same folder).
All works okay but am having trouble picking the next document within the folder to edit.
Using:
Do While Fname <> ""
open Fname, edit and save
Fname = Dir
loop
The same file is being picked each time, and not picking the next file. Is this because the file is being modified and saved in the same folder ?
All works okay but am having trouble picking the next document within the folder to edit.
Using:
Do While Fname <> ""
open Fname, edit and save
Fname = Dir
loop
The same file is being picked each time, and not picking the next file. Is this because the file is being modified and saved in the same folder ?