Goal: create a folder tree and copy files according to an excel list of paths.
- a tree structure containing unlimited numbers of sub-folders and files and the path to this structure.
- an excel sheet listing all the files of the tree structures with the complete path, for instance: c:\my\folder\path\[url removed, login to view]
The excel contain several columns. Two are important in this project: the path and a batch number.
The macro should create a folder for each batch number (batch1, batch2,...) and copy to this batch folders all the files that belong to it according to the excel list. Files must be copied together with their full path.
For instance if c:\my\folder\path\[url removed, login to view] belongs to batch1, the result of the macro is c:\batch1\my\folder\path\[url removed, login to view]
The program may be an excel macro, or alternatively, since the actual files are on a linux server and accessed over samba, it is also possible to address the files directly in shell or through another programming language (php, java) but it must be accessible from windows clients.
24 freelanceria on tarjonnut keskimäärin 60 $ tähän työhön
Hello, I'm professional java developer, but i've got some experience in VBA too. I can do this project for you. Maintance work after delivery is in price. Regards,