All Questions

Tagged with
0 votes
1 answer
13 views

How can i add an undo option at the end the code in powerpoint using excel vba

I need to add a undo command after I save a copy of ppt, the below code works fine and has been written in excel VBA P.S. Application.CommandBars.ExecuteMso "Undo" did not work here Need ...
1 vote
1 answer
35 views

Python: Paste Excel cells with win32com to Powerpoint without losing cell formats

I want to copy and paste an Excel cell range to Powerpoint with PasteSpecial while preserving Excel cell formats. I use Office 2016. My Excel workbook looks like this: You can download the Excel file ...
0 votes
0 answers
21 views

Update existing power point table with Excel range using VBA

I am a VBA newbie. I am trying to set up a process to quickly update an existing power point template using data from an Excel worksheet. I was successful in doing it for charts, and for text boxes, ...
0 votes
0 answers
31 views

Fetch data in Excel depending on a variable in powerpoint

I have a tough requirement i have not managed to solve, hope community can help me on this. I wish to implement a book of products under powerpoint. A marketing team will work on the visual part of ...
  • 1
0 votes
0 answers
19 views

How to import text and SVG images to specific locations on PowerPoint slide?

I have an Excel sheet with text data and links to SVG files. I am looking for macro or VBA code that will import text from specific column to specific text box on slide {TEXT1} and image from folder ...
0 votes
0 answers
44 views

Build a PPT Table from Excel data that contains merged cells

I am a beginner with VBA and am having a hard time building a table in PPT with excel data that includes merged cells. Currently, my code loops through my excel range and brings over rows of data (...
0 votes
1 answer
35 views

Change the data shown on a powerpoint chart

I have an excel sheet that has the data, I have a powerpoint presentation that has a few charts. I need to run a report eveyday, so i am trying to automate it. I wrote a vba script to copy and paste ...
0 votes
1 answer
59 views

How do I modify this VBA code to run through a Powerpoint presentation instead of a worksheet?

A VBA beginner here. I have this problem wherein I have to : cycle through each chart in a given presentation and then adjust its Y axes. I want to automate this process as manually going through each ...
0 votes
0 answers
35 views

How to retrieve the name of a Microsoft Office Theme (PowerPoint)?

I am writing a code that runs in Excel that needs to retrieve the name of Microsoft Office Theme (i.e. PowerPoint theme/template, .thmx file), only knowing its file path. I have found two ways to ...
  • 213
0 votes
0 answers
41 views

Loop through a PowerPoint presentation and replace certain keywords with text

I was hoping to get some help. I have the following code that works on replacing text from a word documents with a certain word in excel. For example I have ClientName in a cell and the Cell next to ...
  • 11
-1 votes
1 answer
58 views

VBA-curser move

I have a user form, there are several frames inside each of them, there are many text boxes, I want to fill the information from top to bottom, but the cursor moves randomly (vertical and horizental)...
0 votes
1 answer
54 views

Copying filtered cells to powerpoint table

Im relatively new to VBA. Im currently trying to run a code that copies filtered visible cells into powerpoint as a table. The dataset is rather huge and will continue to grow. How do I make the code ...
  • 17
0 votes
1 answer
63 views

Add to existing slide, instead of new slide

I copy paste my ranges from XL to PPT. It creates new slides and adds range as picture. How can I make it paste range to existing slide, instead of creating slide? Right now it loops and paste copied ...
0 votes
1 answer
54 views

How to refer to an Open Excel Workbook from PowerPoint VBA ? (without GetObject)

i am writing a program in PowerPoint VBA that needs to send data to an Excel Workbook (wbPool, for which is file path is wbPoolPath). When the workbook is not open my code is working correctly but I ...
  • 213
1 vote
1 answer
62 views

copy paste XL to PPT with 2 ranges

Hello I am using VBA to loop for ranges and copy as picture and paste to PPT slide. I want to know is there possibility to include 1 more range to code. So VBA will copy paste 2 ranges as picture. ...

15 30 50 per page
1
2 3 4 5
82