Find Jobs
Hire Freelancers

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

$30-250 USD

Завершено
Опублікований over 10 years ago

$30-250 USD

Оплачується при отриманні
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 [login to view URL]". 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".
ID проекту: 5193791

Про проект

8 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 for error handling, but it definitely can be done (not just On Error Resume...). I'm in Israel, so google for Jerusalem Time. I'm available Sun-Thurs 9:30-20:00 and can do 8 hours a day (if I'm not on some other project). So lets start with scheduling a time that's good for you. We could even begin immediately (in the morning) and split it in two, continuing on Sunday. You don't pay for time where I'm looking things up. BTW, Google docs now has macros and a nice UI toolkit for creating forms and apps.
$111 USD за 2 дні(-в)
4,9 (6 відгуки(-ів))
3,9
3,9
8 фрілансерів(-и) готові виконати цю роботу у середньому за $182 USD
Аватарка користувача
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 through a teamviewer, if you like. I am able to start work on your project by friday. Looking forward to work with you. Thanks.
$200 USD за 5 дні(-в)
4,9 (75 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 doing the project. Regards, Eyad
$277 USD за 2 дні(-в)
5,0 (2 відгуки(-ів))
3,8
3,8
Аватарка користувача
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 look at my profile and let me know if we can work together. with kind regards Nizam
$250 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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. I think it is not very high price - I am polish so that is attractive for me as well. We can little bit negotiate the price, but of course I will not work for free. Daily I am working permanently as engineer, after work I am writing macros for my customers. If You are interested in, please contact me. Greetings Andrzej
$150 USD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 love to take a look at your project, and offer any help I can. I have over 5 years experience doing this, as well as an associates degree in programming. I know many languages, but the fundamentals are the same across all of them. I know we can make your macros awesome!
$155 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
London, United Kingdom
4,9
9
Спосіб оплати верифіковано
На сайті з бер. 24, 2011

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.