Closed

VBA Excel Macro

This project received 24 bids from talented freelancers with an average bid price of $60 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
24
Project Description

Goal: create a folder tree and copy files according to an excel list of paths.

Input data:
- 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.

Mission:
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online