Đã Đóng

Macro to Manipulate Data in a MS-Word Table

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

Kĩ năng: Microsoft Office, Visual Basic

Xem nhiều hơn: MS WORD , Excel, power point, flash , photo shop , Google sheets , Google forms, Writing skills , data entry , form filling , co, transfer data ms word powerpoint, data conversion ms word data entry, data conversion jpeg ms word freelance project offered getafreelance, data conversion jpeg ms word, cut paste data word table excel, copy paste vba macro ms word, copying data ms projects excel macro, convert excel data word table, companies providing data entry jobs ms word ms excel, audio file ms word data entry job, application macro ms word exel, macro word table excel, import word table access macro, data excel word file table

Về Bên Thuê:
( 0 nhận xét ) Australia

ID dự án: #16984844

15 freelancer đang chào giá trung bình $161 cho công việc này

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! Thêm

$120 AUD trong 1 ngày
(103 Nhận xét)
6.9
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 Thêm

$246 AUD trong 3 ngày
(72 Nhận xét)
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 Thêm

$220 AUD trong 3 ngày
(18 Nhận xét)
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 trong 2 ngày
(26 Nhận xét)
5.3
$155 AUD trong 3 ngày
(18 Nhận xét)
4.7
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 Thêm

$155 AUD trong 3 ngày
(38 Nhận xét)
5.0
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 Thêm

$100 AUD trong 1 ngày
(13 Nhận xét)
4.5
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 Thêm

$111 AUD trong 3 ngày
(17 Nhận xét)
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 Thêm

$38 AUD trong 1 ngày
(9 Nhận xét)
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 Thêm

$111 AUD trong 3 ngày
(3 Nhận xét)
2.0
TetyanaS

I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$122 AUD trong 3 ngày
(1 Nhận xét)
1.8
braineebeesdemo

Project Description Hi , I am looking for someone who can look at stock patterns on yahoo finance and capture pattern information on an excel sheet that I provide. Below are the instructions on how to identify the Thêm

$30 AUD trong 3 ngày
(0 Nhận xét)
0.0
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 Thêm

$244 AUD trong 10 ngày
(0 Nhận xét)
0.0
anoop913

A proposal has not yet been provided

$266 AUD trong 3 ngày
(0 Nhận xét)
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 Thêm

$166 AUD trong 5 ngày
(0 Nhận xét)
0.0