Find Jobs
Hire Freelancers

VBA data transfer to PDF/DOC

$30-250 USD

Awarded
Posted over 7 years ago

$30-250 USD

Paid on delivery
Looking for an expert in Microsoft VBA to review a current project, complete the sections that requires the transfer of data to Word Docs and PDF pages, also provide solutions for the printing and saving of the Workbook. Also want the code reviewed and estimate for time/cost to update code. This was written by someone without VBA experience. Scope of work required: 1. Create the VBA code that links and transfers the required information to the Word Doc Template (ProbableCause). a. Arresting Officer, Agency, Suspect arrested, charges, time and dates. b. Charges need to be input using a dynamic range so that it minimizes the spaced used. c. Officer needs to be able to complete his own statement below the charges outlining his reasoning for a lawful arrest and detention. d. Can the Word Doc be opened automatically when the Tab is clicked? 2. Create the VBA code that links and fills in the required information to the DIC 23/24/25 forms, including the DIC24S (Spanish) and DIC25S (Spanish). a. Prepare all six forms with links that fill in appropriate officer and suspect information. b. Can the Doc be filled and opened automatically when the Tab is clicked? 3. Finish/Create Save Tab page where user can save the entire workbook/userform to jump drive. 4. Finish/Create Print page where user can select the number of copies for each document to be printed. See Print Tab for example. 5. Need a way to CLEAR all data inputted into Userforms and WorkSheets back to a default status, ready for the next user. OPTIONAL: 1. Estimate time to clean up current code. 2. Can Listboxes in Userforms be rewritten to allow items selected or input into listboxes be automatically transferred to their respected WorkSheets and can the Worksheets be automatically updated when changes are made to Listboxes. Want to eliminate CommandButtons that have been created to Confirm/Transfer items to WorkSheets. Overview of Project I have created an Excel VBA userform to help collect and input arrest data that is then transferred to a workbook with a variety of worksheets. Once all the information is entered, several of the worksheets are printed and used as official documentation. The userform is done with the Multipage function and users will start on the left and move their way to the right, clicking on each page and entering the any necessary information. The pages that need links and a brief description are as follows: Page 9: PC (Probable Cause) This is a Word Document (template) that is a legal document, stating the arresting Officer, Agency, Charges, Description of Arrest, Times and Dates. All the information shown should be pulled from with the Userform (pages) or from specific WorkSheet cells. This document is opened via VBA with the appropriate fields filled and should be available for the officer to complete the form by writing his narrative of the arrest. It should be cleared prior to being opened. Page 10: DIC 23/24/25 These are other legal forms (PDF fill-in forms) used in the event a suspect is charged with DWI. Information is pulled from the UserForm or specific WorkSheet cells where necessary. Page 11: Save This page is to be used to allow the user to save the information on a flash drive. It needs to be save prior to clearing all data so that if necessary, they could pull the information up, make changes and save or print the new info. Page 12: Print This page is dedicated to printing the pages required to create a report. The pages that are required shown. The print setup should allow the user to select the number of each page that they want printed. There is a minimum required of each to turn in and some officers like to keep hard copies themselves. So a print window listing each, each with a dropdown box for selecting the number to be printed, along with a print to WHAT printer selector.
Project ID: 11737276

About the project

14 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $296 USD for this job
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have 100% completion ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$100 USD in 1 day
4.9 (393 reviews)
8.1
8.1
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$250 USD in 3 days
4.9 (435 reviews)
7.7
7.7
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$400 USD in 10 days
4.9 (291 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$250 USD in 3 days
4.9 (286 reviews)
7.2
7.2
User Avatar
Hi , I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please provide the excel macro file . Please ping back to discuss the requirements , so that I can propose solution. Why i should be Hired ? I have very good experience 100% accurate solution 100% Time compliance Good Communication I am sincere,honest and hardworking independent freelancer. I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$250 USD in 3 days
4.9 (152 reviews)
6.0
6.0
User Avatar
Hello, I am a very experienced VB.NET programmer, if you want, i can write a nice application with the features that you have specified. Contact me for more info.
$250 USD in 5 days
5.0 (3 reviews)
3.9
3.9
User Avatar
I work very detail and very organizing, the requirement of this project is not very simple, so it will need some time for communication. I'm GOOD at data processing ,VBA programming, and data analysis.
$175 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I believe you are limited by what excel and Ms office can do and the amount of personal management it requires in order to maintain. I believe i can create an application in filemaker pro advance that can do all that and much more, if you are willing to increase your budget a little. This application can grow with your needs and filemaker is a database management tool used worldwide. Contact me to discuss.
$450 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam I have interesting experiences doing applications with VBA. Payroll and taxes application, vacation management application. Please take a look at my profile to see a better list of my acheivements. Thank you.
$244 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Wallis, United States
0.0
0
Payment method verified
Member since Apr 16, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.