Microsoft Word 2010 VBA to rationalise, improve and debug the code

In Progress

I have developed some macros in Microsoft Word 2010 in a document template which provide automation of some simple functions of personnel/HR documents for consistency. Those functions include (i) saving the file with a standardised file name, (ii) saving as a PDF, (iii) inserting electronic signatures, (iv) generating emails to alert people to the new documents, (v) ticking content control checkboxes when something has been done.

The template I call "UNIFIED Employee Contract [url removed, login to view]".

In simple terms, calling the template will generate a new document with some basic content. An AutoNew macro will then run and generate a form, from which the user will make a choice of different letters or memos to be added in to the document. The document becomes a mail merge document, linking to a spreadsheet which is generated from a confidential staff database. A member of staff is selected, and the document is saved in that person's folder. The details are filled in, and then some other functions can be run.

Most of the functionality is run from MACROBUTTONS. The individual documents generated each time are not macro-enabled, but they are attached to the original document template where the code sits.

I have developed these macros in the evenings as something I enjoy. Mostly they work well. I have continued to add more and more functionality. But they have now got too complicated and I need an expert to look through them and rationalise, improve and debug the code. For example, error handling is not very sophisticated. Some functionality still does not work.

I have produced some notes as training for the managers in my organisation who use these macros. I have uploaded this as a separate file.

The macros create a link between our confidential staff database, and the folder structure on our server. In order for these macros to work, I will need to provide a zip file with the entire folder structure (the top level folder path does not matter, these can be easily made to work anywhere).

To start with, I am looking for up to 2 days work and not more than $250. I expect you will find some easy ways to improve the code. Every time I look at it, I can find a better way of doing something, even if I have only 20 minutes. For example, when I first wrote the code, I was using the Selection object, but have now learnt about Range objects, and have started to convert the code to using those. I have also tried to use modular code, but this is not completed. The code is reasonably well documented and mostly quite straightforward.

Please bid if you have a high level of expertise in Word VBA. I would also like good communication, and so good English is essential. Ideally, to save time, we will have an initial session on Skype for about 30 minutes to go through the project. I use TeamViewer to enable access to my PC so that I can demonstrate the macros working.

When you bid, please indicate when you would like to start the project. It does not have to be immediately, because I am not in a hurry. It is better that we arrange together a time to start the project when I am not busy at work, and can respond to queries.

There will be some other very similar related projects to be done after this one.

If you want to post a bid, please be specific about your expertise and what you can do. I do not find it helpful to have general comments such as "I can do that".

Skills: Microsoft, Visual Basic for Apps

See more: word find template, where to find a new employee, where to find a good employee, vba contract work, top project managers, pc expert hr, need to find a word, microsoft project template, mail merge macro, macros expert, look for project managers, look for employee, i need to find the name of an employee, first choice personnel, find the staff, find related word, find it contract work, find a good employee, expert microsoft access, code electronic, what is vba, what is microsoft word, what is microsoft visual, what is microsoft project, what is memo

Project ID: #5193791

Awarded to:

pashute

I too enjoy "excelling" with VBA macros. That's why I'm bidding low. You can see my 100% client satisfaction 5 star record, as well as my portfolio on excel, word and even powerpoint macros. VB is not the best choice f More

$111 USD in 2 days
(2 Reviews)
2.8

10 freelancers are bidding on average $187 for this job

mrbrave

HI......I am VBA specialist working for past 5 years..On this site, I have completed over 100 VBA related projects most for excel, also few for Word.. I have Highly expertise in word vba. I can show my past work throu More

$200 USD in 5 days
(16 Reviews)
4.3
bharanisrihari

Hi, I'm an Excel & Word expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in Freelancer.com. One of the reviews for your reference: More

$166 USD in 7 days
(8 Reviews)
4.0
esalem

Hello, I am VB, VBA, C#, WPF, Java, PHP, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready to discuss and do More

$277 USD in 2 days
(1 Review)
1.0
GaidenFocus

I went through the same experience you have, learning VB for apps for fun and help at work. In many of my projects (especially big ones) the code has gone from crap, to semi-pro. It is a learning experience! I would More

$155 USD in 3 days
(0 Reviews)
0.0
tekrangers

Hi, I read your requirement. Well, I am having 3 years of expereince in VBA. so this job is really easy for me to do. Please let me know if you need more details about my work. Thanks

$195 USD in 3 days
(0 Reviews)
0.0
ednriu

Sir, What You have wrote is clearly enough for me. My proposal is: up to the nend of week 49th to manage remote meeting to fix al details, and I will provide You project up to the end of 50th week. My price is 140USD. More

$150 USD in 10 days
(0 Reviews)
0.0
logoDS761

Hello, i am very experienced vb6 / vba macro coding in all Ms. Office Excel/Access/Word/Powerpoint + Vb.net 2005/2013 and will do this excellent quality for you!

$120 USD in 7 days
(0 Reviews)
0.0
NizamM

Hello Simon, I am based in London, I used to work with a law firm and maintained their VBA based document automation system for 10 years. So I am interested in your project and as I also like vba a lot!. Please have a More

$250 USD in 3 days
(0 Reviews)
0.0
AndroidAll

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel, Word and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$250 USD in 5 days
(0 Reviews)
2.1