Macro to Manipulate Data in a MS-Word Table

Completed Posted 5 years ago Paid on delivery
Completed 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

Microsoft Office Visual Basic

Project ID: #16984844

About the project

15 proposals Remote project Active 5 years ago

Awarded to:

schoudhary1553

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! More

$120 AUD in 1 day
(109 Reviews)
7.0

15 freelancers are bidding on average $161 for this job

avinav606lx

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. Th More

$246 AUD in 3 days
(76 Reviews)
5.8
chriskerpini

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 projec More

$220 AUD in 3 days
(19 Reviews)
5.4
fedalal2

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
(26 Reviews)
5.3
abhinovpankaj

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 Applicat More

$155 AUD in 3 days
(42 Reviews)
5.1
archanaoswal

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 proje More

$100 AUD in 1 day
(14 Reviews)
4.6
prabakarm23

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 Serv More

$111 AUD in 3 days
(17 Reviews)
3.9
FLinCanada

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 More

$38 AUD in 1 day
(9 Reviews)
3.6
TechnoGuruu

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 t More

$111 AUD in 3 days
(5 Reviews)
3.3
tsft

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 engi More

$244 AUD in 10 days
(0 Reviews)
0.0
anoop913

A proposal has not yet been provided

$266 AUD in 3 days
(0 Reviews)
0.0
celestefrancis

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 More

$166 AUD in 5 days
(0 Reviews)
0.0