Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Embed Excel WS into PPTX

EE Pros,

I'm working on a project where I'm trying to embed specific Range Named sections of a Excel WB, into a PPTX (at the end).   The project is to have a PPTX within the Workbook and then with a Macro, launch the PPTX and append the range named sections within the PPTX.

I've attached a mocked up file for your review.

Thank you in advance,

B.
Embed-PPT-Macro.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bright01

ASKER

Shums,  Thank you very much for jumping in on this one.   Two things;  

1.) If you remove any of the Ranges from the list in the WS, then they should not appear on the PPTX.

2.) Can you control where the Ranges are placed on the PPTX?  In other words, can you choose to or control the output location (as in the case of having them appear on different slides?

3.) Can you do the same for objects such as graphics?

I've updated the Worksheet for you with these specific questions.

Thanks again!!!

B.
Bright01_Embed-PPT-Macrov2.xlsm
Sorry..... 3 things!

B.
Shums,

Thank you for the quick response!  Appreciate your assistance on this one.  I'm authoring another "ask" for the additional components that need to be added.  Thanks again.  Hope you will pick up the next one.

Best regards,

B.