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.
15 freelancers are bidding on average $282 for this job
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.
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.