VBA data transfer to PDF/DOC

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.


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.

Skills: Excel, PDF, Visual Basic, Word

See more: vba script transfer data, transfer data pdf excel, transfer data pdf word, transfer data sage vba, software write mq4, software write chip epson, useful software write book, read pdf file data access vba, software write web specs, transfer works doc pdf, adobe api vba print word doc pdf, transfer word doc pdf, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, transfer data excel word using vba, software write book, transfer data excel word vba, vba doc pdf, software write protect software

About the Employer:
( 0 reviews ) Wallis, United States

Project ID: #11737276

15 freelancers are bidding on average $282 for this job

$600 USD in 5 days
(255 Reviews)

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 More

$100 USD in 1 day
(240 Reviews)
$700 USD in 7 days
(226 Reviews)

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
(266 Reviews)

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 rega More

$250 USD in 3 days
(194 Reviews)

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 pr More

$400 USD in 10 days
(143 Reviews)

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. More

$250 USD in 3 days
(138 Reviews)
$80 USD in 3 days
(3 Reviews)
$190 USD in 7 days
(1 Review)

Hi there, I could help you with this job. I've been around for 20 years in developing various VBA apps for Excel, Access, Word, PowerPoint and other progs. I could analyze your sheet code right away and start More

$250 USD in 3 days
(0 Reviews)

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 Reviews)

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
(1 Review)

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 a More

$450 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$35 USD in 5 days
(0 Reviews)

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. More

$244 USD in 3 days
(0 Reviews)