powerpoint excel vba

Hello, I am new to VBA and experiencing an issue with a bit of code I pulled from a resolved thread. I will explain what I am trying to use the code for and then explain my issue and post the code. Thank you for your help, any advice is appreciated. I first needed a code to extract the data...

Hello, I'm trying to copy charts from an Excel workbook to placeholders in a Powerpoint presentation. Below are the codes I'm using: <code>Sub Pwp() Dim wb As Workbook Dim ppt As PowerPoint.Presentation Dim pptApp As PowerPoint.Application Dim sld As PowerPoint.Slide Dim shp As...

Hi, I want after I select slide, copy there charts from excel, I have code as below: Set wb = ActiveWorkbook Set ws2 = wb.Worksheets("C2") Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.Slide Dim cht As Excel.ChartObject Set newPowerPoint = New...

Hi, I'm adding empty slide. Then I want to set Template (slide 6 from 4x3_Cool_Template.potx). But I dont know how to use it? newPowerPoint.ActivePresentation.Slides.Add newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutBlanknewPowerPoint.ActiveWindow.View.GotoSlide...

Hi, I want to copy chart from excel to powerpoint and paste as image: [code] Dim wb As Workbook Dim ws2 As Worksheet Set wb = ActiveWorkbook Set ws2 = wb.Worksheets("C2") Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.Slide Set newPowerPoint = New...

Hello there, first of all please do not judge my English because it is not my native language. The following is my dilema: I have a Excel template in which I insert data from Access. First i make a copy of my Excel tamplate and then insert the data in that copy of the template. The next step...

Hello Im an intern at a ecommerce company, and every day i have have to produce 80 Powerpoints from data that i recieve in an excel file. So i have an powerpoint template, where i need to change 10 fields, fields that i have to pull from the excel file. Each line containing 10 columns of...

Hi Everyone, I am using MS 2010 and i have a question about activate the excel workbook over powerpoint? I opened and closed a ppt file but a blank ppt screen still on. I cannot activate the excel over ppt. I have to show the frm1 on screen because it has confirmation message. Could you...

Hello All, I have a powerpoint file (2010) that has embedded chart objects linked to external excel sources. How do I list all these source file addresses in a separate sheet(including the corresponding Sheet and Range address) using VBA? Thanks.

Dear all, I am trying to copy and paste multiple tables from Excel to PPT, using VBA. This works if I paste it as an Enhanced Metafile Picture. However, I would like to paste it as HTML format, so I can adjust the table later on in Powerpoint. Changing the PasteSpecial parameter in the code to...

Hi, I am preparing a presentation in PowerPoint. It is a monthly deck of almost 25 slides which takes almost 5-6 hours. Is it possible to prepare it through VBA. It includes data coming from different Pivots in excel. Can please anyone help me with any reference on how to do it.

Hello forum, I have charts in powerpoint which are linked to an excel workbook. When trying to change the source data using .SetSourceData, nothing happens. It works if I manually change the data range first, and then re run the code, but I may aswell set the source data manually each time...

Hello forum, I have a macro written in excel vba that updates the source links of charts in powerpoint to another excel file. When running this, the source data uses the exact same range as in the previous spreadsheet (as expected). Old Workbook <tbody> A B C 1 Buyers Sellers 2 UK 23 12...

I have an Excel template that is adjusted weekly that generates about 20 charts, each of which is on a different worksheet. I'm trying to automate the report generation process and have a question about this last step: Just trying to think about getting it to paste onto a powerpoint template...

Hi, I have a workbook with multiple charts and I am trying to create a macro which will take a named chart and paste it as a picture into a specific slide in PowerPoint. The only code I have been able to find (Using Excel with Other Office Applications) is code that uses the active chart, and...

Hi I'm trying to develop a VBA macro which from an Excel workbook will automatically open up powerpoint and paste onto identified slides various graphs and commentary boxes. I've searched a lot of the web and have found various bits of code, but dont seem to be able to get them to work...

Intended Purpose:<o:p></o:p> · Transfer a specified 4 ranges or objects from2007 MS Excel to 2007 MS PowerPoint WITHOUT changing the personally set defaulttemplate set in PPT. · Have the ability to control the size (height andwidth) of range on PPT slide, location of the ranges on...

Hi everyone I have a sheet that uses a UDF to get the weight from a product string Function Wgt(rCell As Range) As Double '*************************************************************** '*Extract the last set of numbers from a cell containing text and numbers. '*i.e. Cooking Onions 500G (C) =...

Hi, I have power-point file which has 2500 slides and I want to create new power-point file with selected number of slides lets say 20 slides from 2500. Which I can control it from Excel VBA (For simplicity I have mentioned number 1 to 2500 in excel and I can select any 20 numbers and new...