VbPanicStation
Technical User
Hi all,
I'm new to programming - using VBA in access 2000. Hoping someone can help me.
What the problem is: I have got three folders - temporary, master & archive folders. All folders have got files in them. What I'd like to do is for the code to move all the files from the temporary folder into the master folder. Conditions: If a file (232-01) with a lower revision exists in the master folder (and a higher revision file 232-02 is in the temporary folder) for the code to move the lower revision file from the master into the archive before moving the higher revision file from the temporary into the master. If a higher revision exists in the master and a lower revision exists in the archive then the code to move the lower revision file straight into the archive and leave the hight revision drawing in the master folder. Don't know where to start - Please Help!!!
I'm new to programming - using VBA in access 2000. Hoping someone can help me.
What the problem is: I have got three folders - temporary, master & archive folders. All folders have got files in them. What I'd like to do is for the code to move all the files from the temporary folder into the master folder. Conditions: If a file (232-01) with a lower revision exists in the master folder (and a higher revision file 232-02 is in the temporary folder) for the code to move the lower revision file from the master into the archive before moving the higher revision file from the temporary into the master. If a higher revision exists in the master and a lower revision exists in the archive then the code to move the lower revision file straight into the archive and leave the hight revision drawing in the master folder. Don't know where to start - Please Help!!!