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.
I want to read set of excel files with different schema from a particular folder using File directory tool, but I need to provide interface to user for a folder browse through which user can select a directory from which the workflow should pick all the excel files. There is a macro for this, that reads all the records from the multiple excel files from a directory, but the file path selection inside the macro is not dynamic, i.e. if I change the directory path the macro throws error for this. Please let me know a solution for this.