Hi, I have a requirement as below:
1. Multiple excel files are available in a shared folder. (eg) Several users enter different transactions in separate excel sheet and place it in a shared folder. 2. There needs to be a routine which will periodically read all the files in the shared folder and import it into journals. 3. In case there are any errors in any row in the excel sheet, that record needs to be flagged off and the rest of the records will be imported. The error line will later be corrected and re-imported again. 4. On successful import, the excel file will be renamed automatically so that the system does not pick them for import again. (For eg) the system will pick the files for import only when the file name is employee id or something like that. Once after successful import, it will rename as "Empl id" + "SystemDate" Clarifications required: 1. Is there a possibility to automatically read multiple files in a location through a routine that is scheduled? 2. How to rename the file once import is successful? Any help is appreciated. Thanks, GR.
