Automating MS office tasks -- 2

I have a macro that I use to clean up documents I convert to word form html. I run it on each document individually and I do this with 50 - 75 files monthly. I am looking for a way to cleanup all the files in the same folder when I click on that one macro button. I have the clean up macro so I need the code that allows me to select the folder the open the document, run my macro save the file with the changes, then move on to the next file in the folder until all the files are done. just tell me where I should insert my macro in the code with comments. something like.


choose the folder

Open file

Run Cleanup macro ()

Save file as docx in folder 2

Choose folder 2

If the folder has another file

Open the next file

Run clean up macro ()

Save document as docx

If there are no more files in the folder

Close word

Tell the user that you are done.

Skills: Visual Basic

See more: ms access odbc php insert, insert recaptcha html form, class xii ms office ms access project banking, excel, visual basic, microsoft office, microsoft access, visual basic for apps, microsoft excel, insert recaptcha html form login code, insert html form joomla, insert html form joomla article, joomla insert html form, html form changes mysql database php, aspnet html form insert table, oracle php insert html form

About the Employer:
( 2 reviews ) Brooklyn, United States

Project ID: #9098321

Awarded to:


Hi, it is my daily work doing Macros, Forms, Formulas, Sinchronize, Cross sheets, consolidate... So, if you think I am your candidate, please call me now. You can see the oppinions from my clients... Hope to b More

$19 USD in 1 day
(0 Reviews)

10 freelancers are bidding on average $26 for this job


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am th More

$30 USD in 0 days
(107 Reviews)

I could do this for you as an independent Windows application (EXE). Tell me what your macro does exactly, so that I can see if I can replicate the steps in the Windows app. Bests, Larry

$30 USD in 1 day
(9 Reviews)

**Good Day!...Within few mins we can complete it. 100% accuracy assured. I'm a Excel VBA Programmer, with 9.5 years of experience. Have developed lots of projects, templates, trackers. Kindly ping me and will guide More

$20 USD in 0 days
(7 Reviews)

I will automate the thing you want after creating one more macro that will open all files one by one from the folder selected by you and made changes as per requirement. once completed it will give you message successf More

$15 USD in 2 days
(1 Review)

Hello, My name is Nathan. I am quite capable of delivering what you are asking for. I am an expert with VBA among many other languages. I can complete this project for you after you officially offer me the project More

$25 USD in 1 day
(1 Review)

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

$61 USD in 1 day
(0 Reviews)

Hello, I was a VBA developer for the past 8 Years. I will solve your problem. I will provide the 100 % Quality Work Meet your TAT. Thanks, Moorthy K.

$30 USD in 1 day
(0 Reviews)

Hello, I got the idea what you want. I can Complete this task within 3 to 4 hours with 100% accuracy. I have 3 years experience in VB,VBA and VB.NET,C# and JAVA development. I have worked with VB6.0 as Front-end More

$17 USD in 0 days
(0 Reviews)

I have done similar file operation tasks which edit hundreds of files on a single click of the button. Let me work on this.

$25 USD in 1 day
(0 Reviews)

Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.

$15 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)