I have created a nExcel program(main_process.xls) in reading an input file and that works fine.
Now I have an issue with processing.
We receive the input file on daily basis with the name store1_input.xls, store2_input.xls and so on.
How do I code, so that
1. the main_process.xls could open each store file individually, process it and
at the end save it as store1_processed.xls, store2_processed.xls and so on.
2. how to prevent all users open the file at the same time? I mean, only one user could process one store file at a time.
For example, if store1_input.xls is opened by an user for processing, when other user attempts to open it, it should give a message "store1_input file is in process".
Any suggestions or code highly appreciated. I am in urgent need of this.
thanks
Bookmarks