I am using the following code to create a PowerPoint presentation.
Sub PowerPoint() Dim ar As Range, R As Range
Dim PowerPointApp As Object, myPresentation As Object
Dim mySlide As Object, myShape As Object
'Dim PowerPointApp As PowerPoint.Application, myPresentation As Presentation...
Dear Excel Wizards,
I am currently a student taking my first class on visual basic. Our class's first project is to create a looping presentation using VBA. Basically, we need to write a code that uses the Loop until function. It is a very open ended question and it is open to creative minds...
I have to produce a large power point presentation for our Xmas party with all of our compliments for the year. I have over 1200 entries on an excel spreadsheet and have been trying to write/research the code to convert this in to a powerpoint presentation but I'm struggling so far...
I have done lots of searching for the answer to this question online, and I have tried maybe six or seven different suggestions I found online, but none that I have tried seem to be work. Therefore, I appreciate any assistance I can get from the community here.
I have a...
Here I am again. I am having problems with a multiple if syntax.
I have three columns
Desired_Presentation (col J) | Award (col K) | SUSP_Date
Desired presentation will be blank or will contain a date.
Award has a dropdown menu with three options LOM, MSM, and FLCROSS
SUSP_Date (col L) should...
I have likert scale data:
-29.0 through +29.5
I have four different likert scales that need to be graphed in some manner.
the original thought was to create a bell curves to demonstrate the commonality of each set of data.
- - That has proven difficult, or impossible as I cant figure it out...
Hi All, I inherited a power point presentation that shows the average, minimum and maximum values from survey response question. I have the underlying Excel data but don't have the work of the person that calculated these things. The average is shown, including the confidence level. I'm not a...
I use the following code to open a presentation and paste some information into a presentation from Excel. The problem that I have is that the users of the excel file have different default settings for their PPT screen ratio on startup. Obviously this throws out my presentation...
How can we use VBA to make invisible or hide an open excel file and power point presentation behind the scene while we work on it.
It works well with excel as I use ActiveWindow.Visible = False but for power point I use
set pres = pap.presentations.open(pth + pptxfile, withwindow:msofalse)...
i'm using VBA in Excel to copy&paste charts as images to a PowerPoint presentation.
I would like to modify the code, so that it's using the existing presentation (which is created after the 1st run) from now on.
My purpose is to update the charts with new ones, while keeping the...
I've been looking for a solution to this problem for a long time without finding anything that works. Hopefully someone out there can help me in the right direction :)
I have an excel-file that contains alot of pivot charts and tables that i need to export to a powerpoint presentation...
Here's a non-codey one for you.
I am about to roll out a group of 5 workbooks and am trying to think of a consistent and eye-catching theme to impress my client.
My standard is
titles with navy background and white lettering
Heading1, Heading 2, Good/Bad...
I'm putting together a pack showing a companies performance year to date, it will essentially be a selection of full page charts and tables.
Is anyone aware of any articles or suggestions as to how best to present this? Whether exporting to Powerpoint or Acrobat are better options etc...
I have a group of 100 agents who have to evaluate a telephone call and then select the type of call from a drop down list of 200 entries. Because all agents have the same chance of getting the same mix of calls, their selection mix should be relatively similar.
I want to be able to show using...