ppt

Is it possible to have two (or more) excel workbooks linked to one powerpoint?> I currently have a financial template setup to compile data/information that is then linked do a powerpoint. This way, at each month end, you select the latest date and the most recent information is populated into...

I am trying to find out if I can mail merge from an Excel database into PPT. Basically, what I want to do is create a new slide for each record/row. Each slide would contain the data from at least 15 cells/columns from the Excel record/row (over 50 cells for each record). Some of those cells...

Hello, Every month I have to manually copy charts from Excel and paste them into Power Point. It is a manual process and I would like to improve it by adding a VBA code. Problem 1: The code below allows me to copy one Excel chart into Power Point each time. I have 3 charts on one tab and i want...

Hello All, I have an existing presentation (a monthly report) that has various objects (charts, tables) linked to external Excel sources. Can any of you help me with a code that will enable to list all the links into a sheet, may be with the slide number, object dimensions, the underlying cell...

Hi, I am trying to make the following steps work but Step 5 (macro) simply does not work. Step 1 I have a worksheet where a user is able to enter data in one tab, Step 2 which is stored in another tab by way of macros, Step 3 which populates cells in another tab, Step 4 the cells will then...

Hello, My VBA skills are quite basic but I managed (partly from copying) to get a Macro to create a ppt slide from a range of cells. Now I would like a button at the cover page of the excel to create the slides for a series of tabs (lets say the third, fourth, fifth etc.) without having to jump...

Using PPT 2010 to link to a large (88 MB) Excel 2010 file. The PPT deck is relatively short, 28 slides, but is 175MB in size. The type of linked data includes roughly 50 charts and 25 instances of text blocks. I am looking for a solution to drastically reduce the size of this PPT deck. I'm not...

I am running a powerpoint show and excel at the same time i. i have macros in excel that run everyhour. but in order to run the powerpoint show powerpoint has to be active. so when i click off of excel to get the powerpoint running it stops the macros from running and if i click back to excel my...

I am running a powerpoint show and excel at the same time i. i have macros in excel that run everyhour. but in order to run the powerpoint show powerpoint has to be active. so when i click off of excel to get the powerpoint running it stops the macros from running and if i click back to excel my...

I am running a powerpoint show and excel at the same time i. i have macros in excel that run everyhour. but in order to run the powerpoint show powerpoint has to be active. so when i click off of excel to get the powerpoint running it stops the macros from running and if i click back to excel my...

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 all, I'm working on a macro to copy data from excel to powerpoint. All ok! Charts are copied and resized, I managed to save the PPT file where I wanted. I got stuck in one point. I'm using the line below to save the file where I want and with the name "I almost Want". With pptPres...

I have a .xlsm that is used in a .pptm. I would like to be able to use a macro to open the .pptm. I have a code that can open it, but does not update the links to the .xlsm when opening. When opening the pptm from the file menu, it asks to update links, but when using macro it does not ask...

I'm hoping someone already has the VBA code for this. I have a linked set of files, one Excel and one PPT with the charts in the PPT dynamically linked to the Excel file. I need to use this set sort of like a template so that I can make copies of both of these under new names and change the...

Hi, I'm planning to automate PPT generation task from excel data. I want to specify the source excel file, the range in different sheets and copy the selected part to PPT. Please suggest how I can go about it. I have basic knowledge of VBA. Thanks a lot!

Hello All! So I'm running this code to extract multiple charts (2) from each worksheet in a workbook and then paste each chart to a seperate powerpoint slide. When the code is run, I get the following error: Line of Code: Set PPTShape = PPSlide.Shapes.PasteSpecial(link:=True) And the...

I need macro that lists the of names of the ppt files that are currently open, I also need the macro to update the list when I open a new ppt file,

There are two of us in separate physical locations (computers NOT networked) working on a xls and ppt file with links in the ppt (both version 2007) pulling info from the xls. The problem we are having is to maintain the links once we have shared the files back and forth. At the present time...