Auto Size in Excel to PPt paste Macro

**jayman7** · 08-27-2009, 05:39 PM

Hello,
I have a working macro where I use a Forms Command Button w/ a Macro that copy/paste specific variables and range in the workbook to a pre-defined PowerPoint template file (in the same directory as the workbook file). See code below:

Questions:

1) Is there a better script to reference a value in a cell value in Excel and Paste in PPT template?

2) Is there away to auto scale the copy range from Excel to PPt? Curently I have to manually adjust the height/width parameters.

Thanks in Advance!

**jayman7** · 09-02-2009, 06:50 PM

Hi,
Is there a way to autosize/fit a cut/paste macro from Excel to Powerpoint slide?
Thanks,
j

**Andy Pope** · 09-13-2009, 07:01 AM

It may help other understand if you post some example files.
The ppt file should have a before and after example of the pasted item.

**jayman7** · 09-14-2009, 05:30 AM

Hi,
I've attached the following;

1. Excel Data file w/ Publish Button (No working yet)

2. Power point template (PPTExcel)

3. PPT Output based on selected tables/graphs from checklist (Not incorporated). Please advise of questions/how to proceed.
Thanks,
j