Post by robert on Jul 1, 2022 14:25:37 GMT
I want to process all files in a chosen folder. The only way I can think of for choosing the folder without editing the macro is via an input box. However, I cannot get variables to work in FOR | EACH | FILE IN | . See minimum reprex below.
This just gives an error message "The path %STRING% does not exist or cannot be read. I have checked that %STRING% does contain the path name correctly, and if pasted verbatim instead of %STRING% this works fine. Is there any other way to achieve this?
1 | RUN ACTION | INPUT BOX | Paste path for files to be processed::Choose folder::STRING
2 | FOR | EACH | FILE IN | %STRING% | DO
3 | RUN ACTION | MESSAGE PROMPT | %FILE.NAME%::File name::2::OK
4 | FOR | NEXTThis just gives an error message "The path %STRING% does not exist or cannot be read. I have checked that %STRING% does contain the path name correctly, and if pasted verbatim instead of %STRING% this works fine. Is there any other way to achieve this?
