Find Jobs
Hire Freelancers

Develop basic Word Macro(s) in VBA to implement document workflow

$30-250 USD

Скасований
Опублікований almost 7 years ago

$30-250 USD

Оплачується при отриманні
I need a series of MSWord (2016) templates developed for office forms - e.g. Leave Application, Expense Claim, etc - that have workflow functionality by means of VBA macros. I want to start with a simple template that can then be used as a basis for other templates. We need a document value, 'ApprovalStatus' that needs to be initially set to '0' (not yet submitted). The form must have a field: 'Name', and a field 'Email Address'. At the bottom, we need a drop down list that will be manually populated in the code, with a label: 'Request Approval From:'. This drop down list needs to store 2 values for each row: name and email address. Like this: General Manager gm @ [login to view URL] Branch Manager bm @ [login to view URL] HR Manager hr @ [login to view URL] etc. But the email address does not need displaying. Next to that list a button labelled "Submit". This button must only be displayed if the document value ApprovalStatus = 0. We also need another button that is initially hidden, labelled "Approve". This must only be displayed if the document value ApprovalStatus = 1. The actions of the buttons need to be: SUBMIT: when this button is clicked the document value ApprovalStatus needs to be set to '1' and saved in the document to indicate that the form has been submitted for approval. The document also needs to store the requestors email addressThen the form needs to be emailed to the recipient selected in the 'Request Approval From" list. Obviously, the form will need to be in a .docx (macro enabled) filetype. The email subject needs to be: "REQUEST: Approval needed; form attached", and the body: "please find attached a form for your approval". APPROVE: when this button is clicked we need to add text to the document at the bottom that says "Approved on: <insert current date and time>, by <insert windows username>". Then the form is emailed back to the originator - we stored their email address previously - and a pre-determined email address we will store in the code. The email subject needs to be: "APPROVED: form attached", and the body: "please find attached the approved form." I have attached a basic Word template with the fields in place, except the drop down list has no data.
ID проекту: 14056519

Про проект

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

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

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

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
we have expertise in Word, Excel - VBA , Data processing. Client satisfaction is our main motto for long term relationship.
$150 USD за 2 дні(-в)
4,8 (4 відгуки(-ів))
3,0
3,0
8 фрілансерів(-и) готові виконати цю роботу у середньому за $183 USD
Аватарка користувача
Hi, I am good at Word document and building useful scripts for my clients. I would like to know about the "Approval Status" part. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$125 USD за 2 дні(-в)
5,0 (234 відгуки(-ів))
6,7
6,7
Аватарка користувача
Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Word/VBA (among other Office apps) and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$130 USD за 2 дні(-в)
4,9 (44 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hello Sir, I have reviewed the details and I would like to work on this Macro for Word. Please open chat to discuss more about this. Thanks Aanvik
$235 USD за 3 дні(-в)
5,0 (22 відгуки(-ів))
5,6
5,6
Аватарка користувача
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create Drop Down with multiple column and access the values as per requirements. I will also create word add-ins program to send email through Outlook by using VBA Programming. I will use all logic and conditions which you described in your project details. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. So, I can do this job nicely. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$200 USD за 3 дні(-в)
4,7 (38 відгуки(-ів))
5,0
5,0
Аватарка користувача
Hello, I am proficient with MS Office and VBA and would love to help you with this project. Most of my projects were based on VBA in Excel, but I have done some projects with macros in Word too. I am sure I could do what you need. Please contact me for more information.
$180 USD за 3 дні(-в)
5,0 (42 відгуки(-ів))
4,8
4,8
Аватарка користувача
Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$180 USD за 3 дні(-в)
4,8 (26 відгуки(-ів))
4,6
4,6
Аватарка користувача
Do you need PDF forms? your all requirements can be fulfilled in pdf forms with java scripting.
$264 USD за 3 дні(-в)
5,0 (12 відгуки(-ів))
3,8
3,8

Про клієнта

Прапор AUSTRALIA
KARRAKUP, Australia
4,9
2
Спосіб оплати верифіковано
На сайті з лип. 9, 2009

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

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