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.

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.

Навыки: Excel, PDF, Visual Basic, Word

Показать больше: 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

ID проекта: #11737276

17 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $283

$600 USD за 5 дней(-я)
(249 отзывов(-а))
7.6
$700 USD за 7 дней(-я)
(214 отзывов(-а))
7.1
elqueabandona

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 Больше

$250 USD за 3 дней(-я)
(143 отзывов(-а))
6.5
wsh2

Technically speaking, this is not a simple project. Sizing free form text to fit, multi-lingual, all derived from a spreadsheet? Very challenging.. - but doable. Nevertheless, I highly commend you on your design an Больше

$555 USD за 9 дней(-я)
(42 отзывов(-а))
6.1
P0L

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 за 3 дней(-я)
(110 отзывов(-а))
6.2
paris2785

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 Больше

$400 USD за 10 дней(-я)
(98 отзывов(-а))
6.1
rengrish

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. Больше

$250 USD за 3 дней(-я)
(117 отзывов(-а))
5.7
schoudhary1553

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 USD за 1 день
(61 отзывов(-а))
5.1
Topfreelancer4

Feel fee to contact me for.Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the clients.Make payment only after the work done.Thank yo Больше

$50 USD за 3 дней(-я)
(5 отзывов(-а))
2.9
$80 USD за 3 дней(-я)
(3 отзывов(-а))
1.6
$190 USD за 7 дней(-я)
(1 отзыв)
1.7
nikpren

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. Больше

$244 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
kerriantimoll3

A proposal has not yet been provided

$35 USD за 5 дней(-я)
(0 отзывов(-а))
0.0
andersonstinger

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 за 5 дней(-я)
(0 отзывов(-а))
0.0
Gazmend

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 Больше

$250 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
$35 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
z66

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 за 7 дней(-я)
(0 отзывов(-а))
0.0
ykroitoro

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 Больше

$450 USD за 10 дней(-я)
(0 отзывов(-а))
0.0