Closed

VBA Excel Macro

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.

Skills: Excel, Java, Perl, PHP, Visual Basic

See more: excel contain, vba contain, excel macro browse folder import files list, excel macro installer, java excel create macro, folder tree excel, excel macro batch, windows batch programming, vba with, vba programming language, vba programming in excel, vba excel programming, tree structures in java, tree structure programming, tree structure in c, tree program in data structure, tree of data structure, tree in data structures, tree in data structure, tree data structures in c, tree data structures, tree data structure in java, tree data structure in c, tree data structure c, shell programming language

About the Employer:
( 0 reviews ) Jerusalem, Israel

Project ID: #436438

24 freelancers are bidding on average $60 for this job

guoxinliu917

Dear oppenheimer, I believe I can do it well for you because I am so familiar with this due to more than 4 years experience.

$30 USD in 3 days
(32 Reviews)
6.1
ender81

I can do the job you need using VBA macro in MS Excel as I have done many similar projects before or I canuse other programming language if you prefer.

$50 USD in 2 days
(19 Reviews)
4.0
kfsw

I'm still learning so price is low, but the job is fast and easy to do.

$30 USD in 1 day
(9 Reviews)
2.9
mbaanalyst

Please check PM.

$125 USD in 2 days
(1 Review)
2.8
AlxP

I can do this with using VBA.

$30 USD in 1 day
(2 Reviews)
1.6
tpb261

I can do it using python/VB/Perl (I prefer Python) Pls see PMB

$30 USD in 3 days
(1 Review)
1.0
cordjr

I have 10 years of experience with java, vb6 and .net i can do this very quickly. Best regards

$30 USD in 3 days
(1 Review)
0.8
np101

I am an IT professional with 10 yrs experience. I have very good experience with VBA excel. I will provide quick & professional service.

$100 USD in 1 day
(0 Reviews)
1.4
sssstechcom

Hi, I have experience in VBA macro. I am working as MIS in a MNC company. I can finish this task within a Day. I hope this will hears you.

$50 USD in 1 day
(0 Reviews)
0.0
vibin3412

I am ready to work on this

$30 USD in 2 days
(0 Reviews)
0.0
inddatawork

Hi, I have sound knowledge in VB and VBA macro. I have exp of 4+ yrs in VBA . Give me a opportunity to work in your carpet

$45 USD in 1 day
(0 Reviews)
0.0
d32

its completely do-able

$30 USD in 1 day
(0 Reviews)
0.0
veersh

I can do this project

$30 USD in 3 days
(0 Reviews)
0.0
yan19

I can do this project in java. Please send a sample sheet so i can send u a webex of the sample code's, working.

$250 USD in 10 days
(0 Reviews)
0.0
jerry12302

I already have existing VBA code for this, and can easily modify it for your purpose. 20+ years of Lotus macro and Excel VBA experience.

$50 USD in 1 day
(0 Reviews)
0.0
GaryB52

I can do this project well and fast

$100 USD in 1 day
(0 Reviews)
0.0
bfrydrych

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,

$50 USD in 1 day
(0 Reviews)
0.0
kustominc

hi, i have experience doing this type of work and i'm available to start on this project for you now. i would create a VBA excel macro that would create the folder structure and move the data all depending on values More

$60 USD in 2 days
(0 Reviews)
0.0
chiksrahul

Lets get it done..

$30 USD in 1 day
(0 Reviews)
0.0
hivishy

I have been doing Excel and VBA for the last 3 years.

$30 USD in 1 day
(0 Reviews)
0.0