Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace más de 10 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 5193791

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 2 días
4,9 (6 comentarios)
3,9
3,9
8 freelancers están ofertando un promedio de $182 USD por este trabajo
Avatar del usuario
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 en 5 días
4,9 (75 comentarios)
6,0
6,0
Avatar del usuario
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 en 2 días
5,0 (2 comentarios)
3,8
3,8
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
4,9
9
Forma de pago verificada
Miembro desde mar 24, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.