How can I get the MD5 hex hash for a file using VBA? I need a version that works for a file. Something as simple as this Python code: import hashlib def md5_for_file(fileLocation, block_size=2**20): f = open(fileLocation) md5 = hashlib.md5() while True: data = f.read(block_size) if not data: br...
We're trying to create a PowerPoint slide programmaticaly. We can obtain bullets on a single level, but playing with tabs and line returns doesn't work for nested enumerations. For now we get: text 1 subtext1 subtext2 text 2 And what we want is : text 1 subtext1 subtext2 text 2 Is there a way to control these using C# ...
I have about 25 PowerPoint presentations, each with at least 45 slides. On each slide is a question with four possible answers and a help button which provides a hint relevant to the question. Each of the answers and the help button is a PowerPoint Action button that launches a macro. I am attempting to migrate all the questions/answer...
I have searched high and low to find some way to try to automate spell-check in VBA for PowerPoint, but have not been able to uncover anything. I'm looking for similar functionality to what Word and Excel offer in automating spell-check, but for PowerPoint The routine I'm after would be like (psuedo): For Each Mispelling in ActivePrese...
I have a lot of presentations that need to be shared outside of my company and I need a way to loop through all the speaker notes and remove them automatically. Is there a way to do this in VBA? I've search on this but can't seem to find anything. ...
I'm looking for a way to programmatically emulate PowerPoint and Word's behavior of compressing pictures to 150 or 96 dpi (ppi) (and removing crops, if there). I need to make a whole ton of presentations and documents smaller for distribution and can't open them up one by one to change DPI by hand for all of them. Is there any way to do ...
I searched extensively on this and incredibly there seems to be no answer. Does anyone know how to do this? ...
So I know how to name a textbox, or a like object in PowerPoint with VB, but I was wondering if there was a way to name objects through the Ribbon (PowerPoint 2007). For instance, if I add a text box onto a slide, is there a way to assign it a name (sort of like the properties window in access, or the textbox in Excel 2003 at the top lef...
I use the Powerpoint Object-Model to programmatically create a presentation in PowerPoint 2007. Some of the computers on which I run my program have PowerPoint set with Hebrew as the Primary Editing Language. (to change the primary language, push the "Office" button, then "Powerpoint options", and go to Popular->Language Settings->Prima...
I need to be able to save Presentations (programatically) in PowerPoint 2003 as OpenXML (".pptx"). I installed the Microsoft Office Compatibility Pack. This indeed allows me to perform "Save as PowerPoint 2007 Presentation" from PowerPoint 2003. How can I do this programmatically? (e.g. VBA) I tried Presentation.SaveAs: While there i...
I'm new to programming in VBA, but what I'm trying to do right now is have a PowerPoint slide that updates every day. It's a weather forecast slide that is displayed in our lobby, and currently I manually update the seven day forecast each day I come in. This means that until I come in, it shows the current day as yesterday's date, and t...
I'm working with a PowerPoint 2003 presentation for a kiosk display, and it is left running pretty much 24/7. One slide on it has the weather, the current date, and the 7 day forecast. I've already written the subs that will update the weather from an Excel workbook, and update the dates displayed, but right now I have to manually upda...
I just came to know that macros in Word/Excel/PowerPoint can be programmed. That is awesome because I've a Word document with 70 tables for styling. I'm a programmer but I don't know VB, VBA or VB .NET. I'm confused with these three. I'm familiar with .NET programming using C#. Now I want to write new macros. Where should I get started?...
I'm trying to find out if there is an equivalent of Excel's OnTime event for PowerPoint 2003; I would like to call a subroutine at a specific time of day. ...
I'm looking at the UpgradeMedia new function in PowerPoint 2010 VBA and want to know if there are any details available about 1. Is it customizable (the output) and 2. What exact media it will upgrade. I haven't found too many details on it, does anyone have any? ...
I am using a macro in PowerPoint 2003 SP3 to find a specified chart in an Excel workbook, copy it, and then paste it into the current slide as an Enhanced Metafile with, ultimately, the following line of code: Application.ActiveWindow.View.PasteSpecial DataType:=ppPasteEnhancedMetafile As often as it works, I also receive the following...
Is there a way to programmatically add an image to a PowerPoint file? Create the file, open the file Add the image Close the file I need to do this to about 1000 PowerPoint files. ...
I have a PowerPoint which contains around 50 slides. Each slide might have 1 or more comments provided by the reviwer (done using insert->comment menu). I am trying to get the comments programatically exported into a text file using this VBA code: Sub ConvertComments() ''# Converts new-style comments to old Dim oSl As ...
In most cases shape.Parent is the slide that contains the shape. However, if you try to delete a a group and then press on undo (the shapes will reappear) but the child shapes will throw exception for both .Parent and .ParentGroup. How can I find out the slide ID of a shape in the case above? ...
I am attempting to write a procedure in PowerPoint 2003 that will allow automatic updating of an installed add-in. The general process is as follows: Uninstall the add-in For Each objAddIn In Application.AddIns If UCase(objAddIn.Name) = UCase(AddInName) Then With objAddIn .Registered = msoFalse .Auto...