Find Jobs
Hire Freelancers

Macro to Manipulate Data in a MS-Word Table

$30-250 AUD

Completed
Posted almost 6 years ago

$30-250 AUD

Paid on delivery
Macro to Manipulate Data in a MS-Word Table This is a request for a macro to run on Microsoft Word and to make some changes to a table and to the cells within the table. You will need experience in writing MS-Word macros and table management. PowerPoint can export a Word document which contains images of the PPT slides in a table. The table is not in a useful format and needs to be changed by a Macro. This will be used for many presentations so the table may have between 5 and 100 slides. Attached is a sample called Input [login to view URL] (with the table as produced by PowerPoint and containing 2 slides) and an Output [login to view URL] (showing what the table should look like after the macro has been run). Please provide instructions on how to initiate the macro. I will require access to the source code. Note that the sample was prepared with MS-Word 2016 and a Windows PC - which is the target environment. The macro needs to do the following: 1. Remove the first column of the table containing slide numbers 2. Remove the last column of the table containing lines (table now has only 1 column containing images) 3. Select the table and: a. in Table Layout - change the height of all cells to 11.8cm and the width of all cells to 18 cm b. in Home/Paragraph/Borders & Shading/Borders - set the surrounding and horizontal borders to colour – white and width - 6pt c. in Home/Paragraph/Borders & Shading/Shading - set the Fill to ‘gold accent 4 lighter 80%’ 4. Repetitively, for each cell in the table, starting at the top cell in the table: a. Select the PPT object in the cell (the image is the only data in the cell) b. Cut c. Paste Special (back in the same location) as Picture (Enhanced Metafile) d. Select the picture (it should remain selected after the paste) e. Change the size of the picture in the cell - Picture Tools/Format/Size/Size/ - Scale - Height 175% (ensure that Lock Aspect ratio is ticked – it should be by default) f. Format the picture by adding a shadow - Picture Tools/Format/Picture Styles/Picture Effects/Shadow - Choose the Outer preset ‘Offset diagonal bottom right’ g. Add some text - Move to right of picture and type ‘Enter’ followed by 2 spaces and ‘Notes:’ h. Move down to the next cell and repeat the changes to the cell - or terminate the macro if the bottom of the table is reached
Project ID: 16984844

About the project

15 proposals
Remote project
Active 6 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
Hello, I can help with you in your project Macro to Manipulate Data in a MS-Word Table. I have more than 5 years of experience in Microsoft Office, Visual Basic . We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$120 AUD in 1 day
5.0 (109 reviews)
7.0
7.0
15 freelancers are bidding on average $161 AUD for this job
User Avatar
Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$246 AUD in 3 days
4.9 (76 reviews)
5.8
5.8
User Avatar
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Word/Excel/PowerPoint/VBA and 13 years teaching them (all levels). I can certainly do excellent work with your project. I think that the best way to run this macro is from inside PowerPoint, with a first part, exporting the slides into the Word doc and then a second part, which will apply all necessary changes to this Word document. Of course it is possible also to have the macro as part of the "normal" template in Word and run it from inside the Word app. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$220 AUD in 3 days
5.0 (19 reviews)
5.4
5.4
User Avatar
I have a lot experience in MS Office automation and I'm realy guru in this. I can help you with this project. Best Regards, Alex
$333 AUD in 2 days
4.9 (26 reviews)
5.3
5.3
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$155 AUD in 3 days
4.8 (42 reviews)
5.1
5.1
User Avatar
I have excellent command on Word / PowerPoint / Excel macros. I understand your requirement of modifying the table created in Word by PowerPoint and know how to make the desired changes. I have completed many VBA projects before and you can see the reviews of the same in my profile.
$100 AUD in 1 day
4.9 (14 reviews)
4.6
4.6
User Avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. Also worked on Word VBA with splitting pages based on Section breaks, Find and Replace texts,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details .Thank you :)
$111 AUD in 3 days
4.9 (17 reviews)
3.9
3.9
User Avatar
I suggest a tool written in Word VBA. The tool would open your input file(s), make the changes, then save the resulting file(s) with a different filename (or location, or both) to indicate that processing has been done. What about capturing the PowerPoint slides in the first place? Do you need that included in the tool?
$38 AUD in 1 day
5.0 (9 reviews)
3.6
3.6
User Avatar
Hi, I have multiple years experience in MS-Excel, functions and macros. I have done this type of projects before also including sending automated email or editing in different file. Please give me this opportunity to work on your project. I will make macro for you which will edit your input file give you final output file. Thanks, Peter
$111 AUD in 3 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Dear Sir/Madam: I offer to make your job. I have worked since Offcie in 95´s version up to 2016's Word integrating with Access. I work any Office DOM with VBA. Expertise since 90s. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. Kind regards.
$244 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$266 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 20 years experience designing, building, and implementing systems - from small utilities to large enterprise-wide applications. Over the years, I've built a variety of Macros to serve when Microsoft simply doesn't do what I want. I find documentation essential so I can easily modify the code or build something similar. Basic plan: - Prepare and test Macro according to your specifications. - Optionally, I can test with your actual data. - Turn over text file of the Macro with embedded documentation. You can install it as desired. - Do your own testing. - Done! Thank you for your consideration. Celeste Francis
$166 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Payment method verified
Member since May 17, 2018

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.