Exporting Multiple Excel Ranges From Excel To PowerPoint Using VBA

[@choktit]

I have to say, you must be an educator because you have a real easy flow about you, seems like you do 10 practice videos before making the posted one because you have so much clarity with every step and the direction of the entire process. Also, I really appreciate the extensive commenting that you do so each step can be read at a later date and be understood! I have 2 questions; (1) Can an array just be a single cell - where I might enter a Slide Title, a label, or possibly 3-4 paragraphs of text? And my 2nd...sometimes you say at the end of your videos, as I have watched several, to give feedback on any other subjects that may give you ideas for future videos. (2) Do You have an existing video on (or here's an idea for a future video, if not) pulling data from Excel, whether it be arrays or tables or charts, and drop them into an existing presentation? All the videos that I have found on your channel always create a new presentation instead. (side note) **I actually think that having an existing presentation may address some of the issues with the scaling of the charts when you bring them over from Excel. Meaning, if there is an existing chart that's already sized and formatted the way you want it in an existing presentation and then, using your VBA you update that chart control with the new chart from Excel -it seems that it might go in better and not have those scaling issues we've seen before. (And a recently added feature with PowerPoint is that you can lock certain objects to help win designing slides... I'm guessing that that just locks the ability to select the object through the UI but using VBA you could still update the chart in the background and maybe it would retain the dimensions) So... Do you have a video demonstrating updating an existing PowerPoint presentation? Thanks again for all the knowledge you share!

[@ashleychatterton6190]

Great video - again! I loved the array code as it was exactly what I needed. I’ve managed to export several ranges into a Presentation template, over several slides, I have set up but now trying to figure out how I clear down the ranges already in the Presentation before pasting the new updated ranges.

[@SigmaCoding]

Like you want to delete the existing ranges there before pasting it?

[@ashleychatterton6190]

@@SigmaCoding Yes exactly. The Presentation I have is updated monthly so I need to export the Excel data ranges into PowerPoint on a monthly basis. I've set up a template where the ranges are pasted to but i need to delete the old ranges to past the new monthly ranges as the data changes each month

[@samanthacruz3630]

@@ashleychatterton6190 would love to know how to do this too

[@zezofator]

Great Video, thanks a million for the effort!!

[@SigmaCoding]

Glad it was helpful!

[@zezofator]

@@SigmaCoding more than you can imagine! Can't thank you enough really :)

[@donballesteros1744]

Hi, can you do a video where you copy multiple ranges and multiple charts contained in different sheets within a workbook AND then position those ranges or charts in a specific position within the slide. The copied ranges or charts need to be transferred to a ppt file with slides already laid out but are blank and waiting for the ranges or charts to be copied into them. You mentioned in one of your videos that perhaps having a workbook which describes the file to open, file to save, position of charts or ranges in slide and the slide no to where it would be pasted may be a good approach. have you tried this yet and if so, can you share that video. Thank you very much for these helpful videos.

[@Eugene-td9ne]

Tks for e informative video! May I know how do u export excel data to a PowerPoint custom layout (say i have a specific PowerPoint layout created in PPT slide master) using vba?

[@stevennye5075]

Nice explanation, very clear!

[@ShaneTedford]

Am I able to export my ranges using existing powerpoint slides or presentations ie. export to a one range to a specific slide and another range to a different slide within a powerpoint template?

[@ninatheiss2895]

Great videos - thank you so much! How would you navigate exporting ranges to an existing ppt slides & objects?

[@freekstegmann8992]

Please be as kind to point me to your video on how to extract the data from each row in excel to a new slide in ppt, thanks!

[@shubhrasingh2147]

Hi, I want to export multiple excel ranges to an existing PPT (NOT creating a new PPT) and particular slides along with formatting (like placing at a proper position in the slide with fixed dimensions). Please help.

[@samanthacruz3630]

Did you ever figure out how to do this? Needing help with this exact same thing too

[@vickimoore7619]

You have the BEST Instructional Video, thank you very much. I am trying to export an Income Statement to PPT, but the background adds a blue color, the actual colors I do have in the headers do not transfer and the formatting is not transferring, such as underlines and bold text, is there a way to fix this?

[@SigmaCoding]

More than likely it's the format pasting that's taking place. In your situation if you do a OLE Object that should do the trick. Here is some code that shows you how to paste it in different formats: github.com/areed1192/sigma_coding_youtube/blob/master/vba/vba-powerpoint/Excel%20to%20PowerPoint%20-%20Paste%20Methods.bas

[@vickimoore7619]

Thank you, I will give it a try and let you know.

[@Mktvlogs80]

Thanks for your video.. may I know how to add all the ranges in the same slide itself

[@SigmaCoding]

Check out the video where I show you how to paste multiple objects to the same slide.

[@julienneregele6703]

Thanks for this video! Two questions -- My ranges pasted but not with formatting like yours shown. Is there a way to specify where in the ppt slide you want the table to go? ie far left instead of center.

[@SigmaCoding]

It's more than likely the paste method you chose. I would recommend you paste it as an "OLEObject" and then just turn of the link. Here is how you define the paste data type. PPTSlide.Shapes.PasteSpecial DataType:=ppPasteOLEObject, Link:=msoFalse

[@julienneregele6703]

@@SigmaCoding thank you!! that worked

[@deankuchta9434]

Hello. This is a very instructive video, and I've used it to great extent to guide me along on a project I've been working on at work. Thank you very much for posting this! However, for some reason in my vba code, I am receiving the "Run-time error '91'. Object variable or With block variable not set" message when the subroutine reaches the "PPTSlides.Shapes.Paste" step. Try as I might, I have not been able to figure out what is causing this error. Can you offer any suggestions as to what might be causing this? The only difference between what I'm doing and what you've illustrated here is that I'm trying to paste into an already existing PowerPoint presentation, rather than a new one created from scratch. Great job on all of your videos! Keep up the good work! Thanks!

[@M1and5M]

Hello. Is there a way to paste the excel table to an active presentation?

[@jillit]

I keep getting "variable not defined" for x in the line For x = LBound(RngArray) to UBound(RngArray). And ideas why?

[@SigmaCoding]

Do you have "Option Explicit" on? That error usually pops up because you didn't declare it in your variables, but you have "Option Explicit" on which requires you to declare all of your variables.

[@jillit]

Sigma Coding right, that must be it! I’ll try again without option explicit. Thanks!

[@gemmynguyen4404]

I have to add an additional step "Dim x as Integer"; Otherwise it doesn't work. Just wonder why you don't need it ^^''

[@_This_Is_Patrick_]

I think KZbin is sabotaging your videos because every time I click one and start watching, it says “Something went wrong Tap to retry”. I am able to view videos on any other channel, no problem.

[@SigmaCoding]

Hi there, so I took a look at the video and it seems to still be up and I haven't heard anyone else mention this yet. Did the issue resolve itself or is it still active?

[@_This_Is_Patrick_]

Yeah this is absolutely ridiculous. Something majorly wrong is going on with your videos.