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)
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
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! Plus
15 freelance font une offre moyenne de $161 pour ce travail
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 Plus
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 Plus
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
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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”
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 Plus
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 Plus
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 Plus