Macro to Manipulate Data in a MS-Word Table

Lengkap Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

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

ID Projek: #16984844

Tentang projek

15 cadangan Projek jarak jauh Aktif 5 tahun lepas

Dianugerahkan kepada:

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

$120 AUD dalam sehari
(109 Ulasan)
7.0

15 pekerja bebas membida secara purata $161 untuk pekerjaan ini

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 Lagi

$246 AUD dalam 3 hari
(76 Ulasan)
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 Lagi

$220 AUD dalam 3 hari
(19 Ulasan)
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 dalam 2 hari
(26 Ulasan)
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 Lagi

$155 AUD dalam 3 hari
(42 Ulasan)
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 Lagi

$100 AUD dalam sehari
(14 Ulasan)
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 Lagi

$111 AUD dalam 3 hari
(17 Ulasan)
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 Lagi

$38 AUD dalam sehari
(9 Ulasan)
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 Lagi

$111 AUD dalam 3 hari
(5 Ulasan)
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 Lagi

$244 AUD dalam 10 hari
(0 Ulasan)
0.0
anoop913

A proposal has not yet been provided

$266 AUD dalam 3 hari
(0 Ulasan)
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 Lagi

$166 AUD dalam 5 hari
(0 Ulasan)
0.0