In Progress

VBA Macro Move Files Based on cell contents

I need an XL macro to refer to list of cells in column A which have a series of source files listed by the user with the full directory path.

eg

A2 : C:\[url removed, login to view]

A3 : C:\Temp\[url removed, login to view]

A4 : Blah Blah

A4 : Blah Blah

The files need to be of any type...word,excel,visio etc.

In an adjacent cell in column B , the target files will be listed by the user with the full directory path.

I then need the macro to move the files listed in the source location listed in column A to the Target Location listed in Column B.

Error Handling:

[url removed, login to view] the target directory does not exist the macro needs to create then move the file.

[url removed, login to view] the source file does not exist. Then the move action is skipped and commented. see Column C below.

[url removed, login to view] the source file is duplicated by the user by accident then the second "duplicated" file move action is skipped and commented. see Column C below.

[url removed, login to view] the target file is duplicated by the user by accident then the second "duplicated" file move action is skipped and commented. see Column C below.

eg

B2 : C:\Mytarget\[url removed, login to view]

B3 : C:\Mytarget\Temp\[url removed, login to view]

B4 : Blah Blah

B5 : Blah Blah

The Macro needs to list the source file as "moved" or "not found" in the adjacent cell in column C

eg

c2 : File Moved sucessfully

c3 : File Not found

c4 : File Move Skipped (duplicate source locations)

c5 : File Move Skipped (duplicate target locations)

Skills: Excel, Visual Basic, Word

See more: vba move file, move file vba excel, vba move cell contents, vba move target cell, vba with, excel macro file location, move contents vba, vba error, xl, word visio, vba word, vba excel macro, macro, macro vba, excel vba macro, excel macro vba, excel duplicate, c3, b3, b2, word macro basic, excel vba word, excel vba create word, xls visual basic, excel vba macro file

About the Employer:
( 0 reviews ) Sydney, Australia

Project ID: #2564080

12 freelancers are bidding on average $51 for this job

ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$30 AUD in 1 day
(87 Reviews)
6.0
ZeusMan

Looking forward to working with you...

$30 AUD in 1 day
(62 Reviews)
5.8
diegogarcia0531

Hello, I can do this job for you, please see my PM

$35 AUD in 1 day
(20 Reviews)
4.8
ExactSystems

Please see a better solution on PMB. regards

$100 AUD in 2 days
(6 Reviews)
4.8
naveenvarthaan

Hi, I completed your "File+Move+Macro" project. Please check the attached file. All you are requirements are completed. Please check for the file in your INBOX Best Regards, Naveen

$30 AUD in 1 day
(13 Reviews)
4.2
piyushdpatel

Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM

$30 AUD in 1 day
(10 Reviews)
4.0
microk

Expert Here.. Please check PM.

$30 AUD in 2 days
(16 Reviews)
4.0
vikashgadia

We r excel macro expert with 13 years of experience

$50 AUD in 0 days
(15 Reviews)
3.6
jaylancer43

Greetings..!! Please check your PMB..!!

$30 AUD in 1 day
(13 Reviews)
3.6
AdamT82

Dear thedoc2or, in response to your job, I am pleased to inform you, that I finished the project, based on information which you provided. I can deliver it as soon as possible. Of course, if you would like, I can show More

$100 AUD in 1 day
(1 Review)
2.6
jamiebull

Experienced Excel developer, would be happy working with such a clear brief.

$120 AUD in 3 days
(1 Review)
2.0
prakashgs

I have the macro ready with me now, I can deliver it to in 1 hour after the green signal from you. Thanks Prakash Reckoners.in

$30 AUD in 1 day
(0 Reviews)
0.0