Find Jobs
Hire Freelancers

Create VBA Code for Excel to imbed pdf

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
I have cell in my spreadsheet that uses to other cells to create the file name and location of pdf files on my hard drive. I have used concatenate to join 3 cells on each row of the spreadsheet to create the pdf file name for that row. In another cell I have the C:\... directory that is the same for all rows. In the last cell I have used concatenate to create the full file name including location. I want to embed the file in the adjacent cell. If not file is found, I want to insert the text, file not found. My file names are located in cell N3..., and are text: "##-######-### NOS MMDDYYYY" The file location is the same for all files and is located in P3...or could be entered as static text: "C:\BOX_FTP\2 TRUSTEE\1 POSTED\1 AVT POSTED" I want to embed the pdf file as an object in the spreadsheet in cell R3...
Project ID: 6444577

About the project

20 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
i am a macro expert and i can do your task with in few hours. Please provide me your excel file so that i can build the macro for you. regards Suresh.
$15 USD in 1 day
4.9 (3 reviews)
1.8
1.8
20 freelancers are bidding on average $25 USD for this job
User Avatar
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$30 USD in 0 day
5.0 (753 reviews)
8.5
8.5
User Avatar
A proposal has not yet been provided
$40 USD in 0 day
4.9 (257 reviews)
7.7
7.7
User Avatar
Hey, I can modify your spreadsheet to add the pdf files as object on click of a button. This will be the most effecient way to go about this requirement. Please let me know if you would like me to work on this project with you and we may discuss the details. P.S. Like you mentioned, the files would be embedded. Thanks and Regards, Shikha (Automyze Consulting)
$25 USD in 1 day
4.8 (98 reviews)
6.4
6.4
User Avatar
Hello, I have done it. Before accepting any bid, just check once what and how I did for this as VBA code. I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases like SQL Server, Oracle, MySQL and MS-Access. I am also well-versed with MS-Office Automation (Excel VBA/Macros, Word Macors) and the MS-Outlook Automation for Add-on and Plug-ins. Please check my tremendous 119 feedback on freelancer.com to know more about my client's views for my work. Please also check my portfolio for some software designs for windows applications. I have already implemented it and tested. I have done with all the scenarios like deleting the previous embedded objects if VBA code is run again and again to Reset it with the Current Files (case is always have the latest file in embed object). I can not attached the file in this message as freelancer does not allowing it. so when you initiate the chat-message it then allowed to send you the file. Before accepting any bid, just check once what and how did for the VBA code. Please initiate the discussion on freelancer or Skype so we can move further for the work and give the excel VBA code with sheet. Awaiting for your prompt response. Thanks, Dhirendra
$30 USD in 0 day
5.0 (52 reviews)
5.4
5.4
User Avatar
Wow, this is nearly the exact same job I just did 2 days ago. I can send you a copy of what I produced for that client and if desired I could do similar for you. I can provide you with a locked example before you even accept my bid. I look forward to helping out. UPDATE: Have you ever thought of just making a hyperlink to that file path?
$15 USD in 0 day
4.8 (70 reviews)
5.4
5.4
User Avatar
Hello, I can help you. Pls check my portfolio and contact me if interested. Thanks, Tom __________________
$30 USD in 1 day
4.9 (34 reviews)
5.2
5.2
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$25 USD in 0 day
5.0 (35 reviews)
5.0
5.0
User Avatar
Hi, Yes, I can do it exactly as you described with project post. Please send me source excel spreadsheet so I can create formula and generate full filename. I look forward for your reply soon. Thanks, Ashok
$15 USD in 0 day
5.0 (27 reviews)
4.5
4.5
User Avatar
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do this vba for you. Just have a quick question. Will you like to embed pdf for each row at separate instance or all at one go with just click of a button. Please message me so that we can proceed further. Thanks ! Regards Dan
$30 USD in 1 day
5.0 (11 reviews)
4.6
4.6
User Avatar
i have 2+ year experience in ms - Office i also have experience in Programming (VB, VB.net , C#.net, VBA ) 100% work satisfaction Guarantee ready to start working soon as assign work will be submitted within 5-6 hours after get awarded
$10 USD in 0 day
4.9 (26 reviews)
4.3
4.3
User Avatar
Hi, I am ready with macro VBA code to insert pdf file object in excel. I can send you demo VBA script if you want to check it. Kindly let me know. Thanks, manishadk
$30 USD in 1 day
4.8 (17 reviews)
4.1
4.1
User Avatar
Software developer since 2000, specializing in Visual Basic, SQL server, Crystal Reports/VBA for Microsoft Office
$25 USD in 1 day
4.9 (10 reviews)
3.6
3.6
User Avatar
Good morning! Excel tools 4 years experience with Visual Basic App and C # for macro, libraries and dll. 10 years developer php and VB Systems Engineer Linux / Unix scripting and Admin DB what version of excel used ? demo ready please contact the sending the file
$30 USD in 1 day
5.0 (4 reviews)
2.2
2.2
User Avatar
La propuesta todavía no ha sido proveída
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have more than 8 years of experience in VBA programming and have handled multiple such projects. Currently I work with one of my friends in freelancing, planning to start something on my own. Kindly check my work if it suits your requirement, kindly consider me as one of your option. Regards, Manish
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Proposal belum diberikan
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hot Springs, United States
4.9
18
Payment method verified
Member since Apr 13, 2009

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.