Hello,
My project is really simple for someone who knows visual basic (I would also consider a solution using .net or c++).
On a shared drive, I have a folder with .doc (MS word) files. I have an MS Access database with the list of all these .doc files along with what I call "criteria" that define in which case each .doc file applies.
What I need is a macro in MS Excel (with a relatively nice UI if possible) that will prompt the user for information (criterias). Once it's done and the user clicks OK, I need the macro to query the database, identify the sub-list of .doc files that correspond to the list of criteria defined by the user. Then I need the macro to copy these .doc file in the folder that the user specifies.
The requirement are:
1/ Before the user clicks OK, the list of .doc files (+ description) should be generated for him to validate. The user should be able to come back and correct 1 of the criteria if he needs to (without re-entering all criteria again !).
2/Code should be flexible. The number of .doc file, the criteria, the names of the .doc file will change in the future. I need to be able to update the code when this happens.
I will provide the access database and the .doc forms. You will be free to add anything useful in the database if you need it for the macro.
Thank you
Hello Sir, This is a simple work. I have a lot of experience is such type of module. As I have developed so many backup utillities software which have similiar work as u need.