The PC HelpSite
www.officehelp.biz
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
Automatic Copy/Paste for Microsoft PowerPoint®

Application Microsoft Excel Version 2.10
Author OfficeHelp
Tested on versions: 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 2003

Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Microsoft Excel® in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.

Contact Us for Support FREE DEMO

Automatically update hundreds of Microsoft PowerPoint slides, charts and tables from Excel in minutes.
With the click on a button.

Easily configure the updates you need:

  • Copy from multiple Excel files;
  • Resize and place pasted charts & tables – or just keep their original size & position;
  • Keep the existing chart/table sizes and positions to avoid changes to the slide layout – or change them at will;

Let Excel do the work for you! Update hundreds or thousands of objects on a single run, in minutes.


Download the FREE DEMO. It works exactly as they Full Version.

  • Use your own Files – test for free with your own PowerPoint presentations and Excel source files, see the results for your own needs;
  • Supplied with sample data and ready to run – Including a sample PowerPoint presentation and Excel source file, so that you can immediately test it and understand how it works before trying with your own files.;

Download your FREE DEMO here! 


Really EASY to use - Create a list of PowerPoint commands in plain Excel cells and Run then with a button click!

Simply create a sequential list of commands filling in the necessary values for each operation:

  • PowerPoint Target File: Define where on a PowerPoint presentation the updates should be applied (slide, chart, etc);
  • Excel Source Data: Define where in an Excel source file to get the updates data / charts (file, sheet, chart or range);

Click the Run button and watch PowerPoint updating itself with the newest data from Excel.

Screen Shot from the Microsoft® Excel Macro File (Click to Enlarge)

PIC. 1 - Screen Shot from the Microsoft Excel Macro File (Click to Enlarge)

Based only in EXCEL & POWERPOINT - No installation or setup required. Just open in Excel and run! PowerPoint will be remote controlled by Excel. 


MULTIPLE PowerPoint Operations available

10 available commands for remote controlling PowerPoint from Excel...

  • Update Existing Charts / Tables (Click to Enlarge) – with no changes to slide layout. Keep the existing size, location and name. The existing chart or table is erased and replaced by the new one, maintaining the slide layout and all other existing objects:

Update Existing Charts / Tables – with no changes to slide layout (Click to Enlarge)

  • Add New Charts / Tables to slides (Click to Enlarge) – optionally defining their size & position. Add new charts & tables to existing or even new slides, defining its size, location and name:

Add New Charts / Tables to slides – optionally defining their size & position (Click to Enlarge)

  • Remove existing Charts / Tables (Click to Enlarge) – Erase charts or tables from existing slides when necessary:

Remove existing Charts / Tables(Click to Enlarge)

  • Hide/Unhide Rows & Columns – Adjust what you copy before pasting Excel ranges – copy the same range twice, hiding some rows or columns between them (example: YTD or Quarter P&L for a financial presentation);
  • Save the File to Disk – So that you don’t lose everything already done;
  • Quit PowerPoint – Close the file when it's done;
  • Add / Delete Slides - to the PowerPoint file;
  • And more...


Download the FREE DEMO. It works exactly as they Full Version.

  • Use your own Files – test for free with your own PowerPoint presentations and Excel source files, see the results for your own needs;
  • Supplied with sample data and ready to run – Including a sample PowerPoint presentation and Excel source file, so that you can immediately test it and understand how it works before trying with your own files.;

Download your FREE DEMO here! 


Automatically update hundreds of PowerPoint slides, charts and tables from Excel in minutes.With the click on a button.

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (OfficeCopier2.xls). Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file). Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. There is a "HOW TO RUN THE MACRO.TXT" text file on the ZIP with a full description of its contents and how to use it.

Based only in EXCEL & POWERPOINT - No installation or setup required. Just open in Excel and run! PowerPoint will be remote controlled by Excel. 

We can create the Command List for you

If you want, we can set the macro to update YOUR POWERPOINT presentations. So that you will only have to click the Run button to have it automatically updated.

Contact Us with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.


ADVANCED SETTINGS

The Automatic Charts Copy/Paste for Microsoft PowerPoint  allows for multiple customizations and options, from simple color formatting to error diagnose and data input help.


DATA Entry Help

Excel will help you fill the necessary command cells, guiding users through the process and clearly indicating what is necessary and what is optional.

White cells must be filled, Grey cells should stay empty and yellow cells are optional (colors can be changed and Data Entry help may be disabled). - (Click to Enlarge) 


START / STOP when necessary – PARTIAL RUNS

There is no need to always run all commands:

  • Individual commands can be commented and will be ignored;
  • Use the STOP command anywhere to stop the macro from proceeding further on the command list;
  • Stop if an ERROR if found – or log the error and proceed to the next command to avoid interruptions;


COMPLETE AND USEFULL FEEDBACK

All executed commands report their success STATUS, DATE & TIME and a specific feedback message.

ERROR messages are complete and informative, including all details for easier corrective action. Error rows are painted with different color for easier identification of problems.

3 rows with color & log reporting (Click to Enlarge) 


SELECT THE COLORS

All cell colors can be defined on the CONFIG sheet. Just apply to the sample cell the desired background color. The new colors will be used on all future utilizations.

Color options on the CONFIG Sheet (Click to Enlarge) 


Download the FREE DEMO. It works exactly as they Full Version.

  • Use your own Files – test for free with your own PowerPoint presentations and Excel source files, see the results for your own needs;
  • Supplied with sample data and ready to run – Including a sample PowerPoint presentation and Excel source file, so that you can immediately test it and understand how it works before trying with your own files.;

Download your FREE DEMO here! 


Automatically update hundreds of PowerPoint slides, charts and tables from Excel in minutes.With the click on a button.

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a ZIP file containing the macro Microsoft Excel file (OfficeCopier2.xls). Click on this link and save the file to your own hard drive. You will need to unzip it (extract the Microsoft Excel files from the compressed ZIP file). Once extracted from the ZIP file, just open them with Microsoft Excel every time you want to use it. There is a "HOW TO RUN THE MACRO.TXT" text file on the ZIP with a full description of its contents and how to use it.

Based only in EXCEL & POWERPOINT - No installation or setup required. Just open in Excel and run! PowerPoint will be remote controlled by Excel. 

We can create the Command List for you

If you want, we can set the macro to update YOUR POWERPOINT presentations. So that you will only have to click the Run button to have it automatically updated.

Contact Us with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.


Excel / Office Consulting Services

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.

CLICK HERE TO CONTACT US.


Contact Us for Support FREE DEMO


Get FREE PC TIPS every month:

 

www.OfficeHelp.Biz

(c) 2004 - 2024 OfficeHelp.Biz