asked on

Embed XL WS and Objects into a PPTX

I have a very simple, elegant Macro that Shums helped me with that I need to take to the next level. One item, two questions;

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?

Thank you in advance!

B.
Bright01_Embed-PPT-Macrov2.xlsm

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

Gowflow! Very well done for question 1. I played with your solution and I see that if I put on a Range4, it validates it and then based on a formula you have, it places the Range on the PPTX. If I change the Top and Left variables, it changes the location on the PPTX. Excellent. I can make that work.

Earlier today, I defined a range that included an object (e.g. a Graphic within the WS) and it did transfer the Object. I think there is a way to identify the Object or Graphic itself and pass it on to the PPTX. I'll play with the graphic that's on the WS I sent you and see if I can get it to behave given you have given me the skill to place the range in the right location.

Back with you shortly. And thanks so much!

B.

Jacques Geday

Should I expect you will post something ? or ... ?
gowflow

Bright01

ASKER

Gowflow, Thanks! I need to play with this a little more. What you have provided is a great next step for what I needed. Appreciate your efforts on this. I'll author another question if this needs more work. In the meantime, thanks again!

B.

Jacques Geday

ok do not hesitate to message me the link once you are ready I will gladly continue.
gowflow

Bright01

ASKER

Thank you. You are truly a "professional".

B.

Jacques Geday

Thank you I am faltered.
gowflow

Bright01

ASKER

Gowflow, here is the follow-on to the work you and Shums did. I need the PPTX to be a embedded PPTX that works as a embedded PPTX that has been created and modifiable. In other words, it will be a PPTX that has already been created. Then I add the range name locations (where the EXCEL Range Names or Objects should be embedded).

Hope you may pick this up as another "challenge" ;-)

https://www.experts-exchange.com/questions/29024076/Tweek-to-PPTX-within-a-WS-Launch-and-Content-Capability.html

B.
Embed-PPT-Macrov3--Autosaved-.xlsm