Find Jobs
Hire Freelancers

Write a VBA Script that populates a PDF form

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I have spent a lot of time trying to write this scope as detailed as possible. Please read and understand it thoroughly before bidding the job. If you understand it please Chat with me to clarify any questions. If you messenger me and have not reviewed the attachments, you will not be considered. I need the project completed for Monday. I will only be available until 5:30 EST today to assist you instantly. After that I will be slow to respond until Monday, where I will be available for immediate assistance. Once completed, I will have several more projects basically the same. I will want to replace all of the WS that begin with “SO_” with the same type of script. I look forward to working with you. I have attached 2 Files. The one named Pricing V100 has many worksheets. The worksheet I need replaced is the “SO_Eagle”. Instead I need a script that will populate a PDF form. Currently I click the “Fill” button on the “SO_Eagle” WS and it runs the “SO_Eagle_Fill” script. The problem is that I can no longer use that WS form I created in Excel. I must use the PDF that they have provided (See Attached PDF Form named “ORDER FORM 5.0”). The scope of work for this project is as follows. 1. Create a script that when executed, will populate the PDF Form named “ORDER FORM 5.0”. 2. The logic on how to obtain the data to populate the fields can be located in the script “SO_Eagle_Fill” 3. The “ORDER FORM 5.0” form will always be located in the following directory, a. G:\My Drive\001Pricing\Eagle\Purchase Orders\G:\My Drive\001Pricing\Eagle\Purchase Orders. 4. Once populated the PDF would be saved (remaining editable) to the same directory that the Workbook is currently saved in. a. For example. If the WB Currently is saved as G:\My Drive\001Customers\6 Quotes\Example Client. It would save it there. 5. Create a save naming scheme. a. The PDF should be named using the PDF the current Workbook name and append “Eagle Order” (WB name can be located in ‘Contract AD3’). b. For example, the current WB name is Example Client, so the PDF would be named Pricing Example Client Eagle Order.pdf. Thank You for your time and consideration.
Project ID: 21735337

About the project

20 proposals
Remote project
Active 4 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
20 freelancers are bidding on average $153 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$240 USD in 5 days
4.9 (340 reviews)
8.0
8.0
User Avatar
Hi there,I am VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$220 USD in 7 days
4.9 (123 reviews)
7.3
7.3
User Avatar
Hey there ! I would love to help you out with this project. I specialize in Virtual Assistance and an Excel Expert. I'm Great with Excel and a Detail Oriented person, whom delivers given project on deadlines. I read through the entire project and understood it. I am able to provide my work and show that I am capable of handling your project, as this is an Ideal Project for my Capabilities. I have completed a similar project where a VBA script was needed to populate a PDF from the excel sheet. Check my reviews to an idea about my work. Hope to hear from you. Drop me a message so we can talk abit more. Thanks :)
$100 USD in 1 day
5.0 (33 reviews)
5.8
5.8
User Avatar
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$155 USD in 1 day
4.9 (46 reviews)
5.7
5.7
User Avatar
Hello, I am Luis and I will be glad to assist you with your Excel project. I can replicate the form and save it as PDF as you're needing. I read the requirements and then we could discuss all the details before starting. Please contact me by chat then we could discuss further details about your project! Kind regards, Luis Romero
$150 USD in 2 days
5.0 (129 reviews)
5.6
5.6
User Avatar
Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
$194 USD in 3 days
4.6 (45 reviews)
5.5
5.5
User Avatar
Hello, I can build your vb script perfectly. I have rich experience in it. Hope to work with you. Thanks
$200 USD in 7 days
5.0 (3 reviews)
4.4
4.4
User Avatar
Hi, I reviewed you Fills, and as I see you currently have such script for populating PDF files which has one minor issue (the name of "SO_Egl" workbook is not correct in script (its written as "SO Egl"). I corrected this and your script is working perfectly. By this correction, if you now press "PDF" button in "SO_Egl" workbook it will generate the desired pdf file. please send me message and I will send you the corrected file and if you want more on this script I will be at your service, best regards
$30 USD in 1 day
5.0 (11 reviews)
4.3
4.3
User Avatar
Dear Client. I've read your post carefully. I am a VBA and Excel Expert. I can fulfill your requirements within short time. Please contact me and discuss more. I'll wait for your reply. Best regards. Gui Cai.
$140 USD in 7 days
5.0 (5 reviews)
3.9
3.9
User Avatar
Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am sure i can give you good result . If you award me for your project, you will get good result . looking forward to work with you. Thanks regards
$140 USD in 7 days
4.8 (24 reviews)
4.2
4.2
User Avatar
I checked your project: Write a VBA Script that populates a PDF form and I am totally sure that I am able to accomplish it ! I am very good at Excel, Visual Basic. Hi Christopher T.! Please Send me a message so that we can discuss more about this project
$155 USD in 2 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Hi..I am an expert professional and have created various CRMs on VBA/Macros. I have understood your requirement and would be able to write a VBA script which populates the pdf form. I would like to share some sample sheets of similar projects I have completed in the past. Please let me know if you want to go through those reports with me. Regards Excelologist- Neeti
$200 USD in 5 days
5.0 (1 review)
2.0
2.0
User Avatar
Hello, I can do this for you I just wrote a little test script! I can get this done shortly for you all the information I need seems to already be there so I won't have many questions, I am unable to initiate a chat so if you have any questions or how we will go about it, get in touch - Thanks, Steve EDIT: This is almost fully working I got bored ;-) let me if you would like to see or me to finish it, thanks
$140 USD in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
I saw Pricing V100 and ORDER FORM 5.0. I can start your project immediately. I can complete it monday. I can provide full-time communication and work your time-zone. If you give me a chance to serve you, I will provide a high quality product within the deadline. Best Regards
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Virginia Beach, United States
5.0
42
Payment method verified
Member since Feb 27, 2014

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.