This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Could you give me a demo as you described above. I was actually planning to integrate this into a standard macro which we built in order prepare an analysis upon each workflows and macros which we are currently running so that we could prepare some analysis of the time consumed by each workflow.So this "test_exec.xlsx" needs to be created if it does not exist and if it is existing, the current row needs to be appended below existing lines.
@afv2688 has a good solution, but you can accomplish the same result in a simple workflow...no macros required.
The Output tool on the top branch is configured to create the file if it doesn't exist. The bottom one appends if the file does exist. The directory browser read the files from the target directory and joins this with the list of filenames from the data. Matches, which correspond to existing files, are routed to bottom output. Non-matches go out the L output where the file is created.