Linking To Specific PowerPoint Slide
Jan 17, 2014
I have a table in excel where I'm trying to hyperlink to specific side in a powerpoint presentation. I've found various sites instructing me to use #slidenumber (eg #4) at the end of the filename when editing the link, however many different combinations of slide numbers and names i use it refuses to open the deck at that set slide, always taking me to the beginning. I've tried using the bookmark option in excel but that gives a error messaging stating bookmarks cannot be used in xml files.
View 1 Replies
ADVERTISEMENT
Feb 18, 2013
I am using an excel spread sheet as a larger display on a huge projected screen with numbers at a large charity event. It is a reverse raffle, so as your name is called you are out of the raffle. I would like to link the cell to a specific powerpoint slide which has the name and town of the specific ticket buyer. When double clicking on the cell listing their number the ticket buyers name and town would appear as a powerpoint a window in the middlle of the excel screen for all to see and then disappear after a few seconds or disappear when the next cell is double clicked. putting excel data into powerpoint slldes but not the other way around!
View 7 Replies
View Related
Dec 2, 2011
Code to go to a certain slide in Powerpoint. I kept trying to run the code in Excel VBA and it never worked.
So I said "why not try this code in Powerpoint to see if it works?' and, low and behold, it worked!
What I need is to get the code below, which works in Powerpoint VBA, to work in Excel VBA.
Code:
Sub gothere()
On Error Resume Next
ActivePresentation.SlideShowWindow.View.GotoSlide 3
If Err 0 Then ActiveWindow.View.GotoSlide 3
End Sub
View 3 Replies
View Related
Feb 19, 2012
For the chart in the excel worksheets, does anymore know who to copy it to the powerpoint slide with VBA? (either straight copy and paste, or copy and paste in as picture?)
View 4 Replies
View Related
Aug 2, 2013
I am trying to write a macro that goes in an excel file that creates a powerpoint presentation, and puts four (4) charts in each slide.. I currently have a code that is pasting all of the charts in the same slide and I can't figure out why it isn't working (side note: I haven't attempted to resize or relocate the pictures on the powerpoint slides yet)..
Code:
'Add a reference to the Microsoft PowerPoint Library by:
'1. Go to Tools in the VBA menu
'2. Click on Reference
'3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay
'keep button in same location
Set btn = ActiveSheet.Shapes("CommandButton17")
With btn
btLeft = .Left
btTop = .Top
End With
[code]....
View 2 Replies
View Related
Oct 28, 2011
Which the best procedure to copy a chart into a powerpoint slide from a excel workbook? So that when I update the chart data in the excel workbook I can update it even in the powepoint slide ....
View 1 Replies
View Related
May 6, 2014
I have an excel that gets updated monthly for reporting. The goal is to get the graphs to update automatically by linking them from excel into power point. This is relatively easy but what when I go to update the report for the next month the data for the old power point changes as well. Is there a way to prevent this?
View 1 Replies
View Related
Sep 19, 2013
I'm looking for the below requirement:
Name
Date
Sales1
Sales2
Daniel
01/18/11
4,907.00
2,038.00
[Code] ..........
Required output....
Name
Date
Sales1
Sales2
Name
Date
Sales1
Sales2
[Code] ......
Need macro code to segregate the data...
View 1 Replies
View Related
Dec 11, 2013
I'm trying to link specific data from one workbook to another. So from the demo I've attahced, I need all of the 3rd row "ATP BASIC SERVICE : 1" to be linked to another workbook.
So normaly I could copy the row, go to the other workbook, "paste special" and link it to a column.
The only problem is the "ATP BASIC SERVICE : 1" data will not always be on the 3rd row.
So i assume I would need to automatically search for "ATP BASIC SERVICE : 1" and if it is found, copy the column over to the other workbook.
View 4 Replies
View Related
Mar 1, 2013
What can I do with this data?
In the year 2004 I designed and built my own solar hot water heater box. It works very well and saves me and my family a lot of money every month.
To understand what was going on inside and out of the heater box I purchased a commercial interface unit that consists of a circuit board interfaced to my computer via a serial cable. There is also suitable software provided by the supplier which appears to be a Visual Basic programme or something similar.
The circuit board interfaces eight sensors. These are defined as:- Input (Zero), 3.9 M, 7.8 M, 11.7 M, 15.6 M, Outlet, Internal air and External Air. The metre distances occur by dividing the entire length of the water pipe into equal distance between Inlet and Outlet.
Once the software is set up and "started" it automatically dumps the data (which I record at five minute intervals) into an EXCEL Add-in file. At the end of a day I save the Excel file and then manipulate the data into a chart which gives a picture display of all the sensors and the temperatures recorded.
I have attached a typical Excel file for one day. I try to record most days, but if the weather is overcast and no sun appears there is little or no point in recording.
I am already au-fait on how to use Excel for Min and Max temperatures and chart creation, but I would like to ask everyone how I can add a slide bar to the top of the graph to show temperature readings?
People who read this forum thread should note that once the sun starts rising (around 08.30am) then the water in the solar heater rises dramatically. This can be seen on the attached chart.
View 10 Replies
View Related
Jun 2, 2014
In the following macro, how to get the name of the chart as the slide title?
PHP Code:
Sub Range_Chart_1()
'Requires a reference to the Microsoft PowerPoint Library via the Tools - Reference menu in the VBE
Dim PPApp As PowerPoint.Application
Dim PPSlide As PowerPoint.Slide[code]....
View 2 Replies
View Related
Jul 31, 2009
After we all spend lots of time developing a macro, we have the desire to show others who may not understand or appreciate what is going on during the time the macro is running.
What is the best way for Excel to explain/display what it is doing in "Laymens Terms" WHILE it's running? (if possible).
I was thinking of something like a slide? It would be good if the text can change at points decided by the person who put the macro together.
View 14 Replies
View Related
Mar 28, 2014
I am looking to put a chart in PowerPoint and source Data in to PowerPoint. So all I have to do is to update in PowerPoint. Is there a way to do it?
View 1 Replies
View Related
Jun 9, 2005
I need to export serveral charts to several slides within PowerPoint from Excel Using VBA. I use 2002 versions. I added chartobjects (2) under 1 but not sure if that is the correct placement to start adding more charts to slides.
Private Sub CommandButton1_Click()
'Sub PowerPointOLEAutomation()
Dim ppt As Object, pres As Object
'Create a Microsoft PowerPoint session
Set ppt = CreateObject("powerpoint.application")
'Copy the chart on the Chart Labels Demo sheet
Worksheets("sw dr").ChartObjects(1).Copy
'Worksheets("sw dr&ot").ChartObjects(2).Copy
'Create a new document in Microsoft PowerPoint
Set pres = ppt.Presentations.Add.........................
View 4 Replies
View Related
Feb 21, 2014
So I have lets say 3 workbooks and on each first tab of that worbook there is a (pivot)graph. Now what I would want is VBA code which opens these excel workbooks, then copy the chart and paste it into a powerpoint presentation each chart on a new powerpoint slide. So it can be rather basic. A loop which goes thru excel sheets and always takes the chart on the first tab. I see a lot of different code but not what I really can use for powerpoint thru excel vba.
View 2 Replies
View Related
Sep 22, 2008
I have some VBA code that allows the user to open a linked powerpoint presentation from an Excel workbook. It works well but it does not ask the the user to update links so if the Excel book has changed the powerpoint stays the same. I am very new to VBA so I tend to copy things that work but don't always know why! Anyone out there know how to get it to update links automatically or at least ask the user to do so? Here is the code:
View 2 Replies
View Related
Jun 10, 2011
I need to do a find and replace in PowerPoint but using Excel VBA.
View 5 Replies
View Related
Sep 28, 2012
I have a monthly task where I collect raw data, and make up various charts in PowerPoint.
I have been making the charts in PowerPoint as previously, the file size of the .ppt was too large as it was embedding the Excel sheets into the PowerPoint. Is there any way I can set up sheets in Excel so that I can update them every month and then run a macro so that it updates the graphs automatically (without the embedding)?
I think copying them over as a JPG might work but is there any other way? I have no idea about the code needed, and I'm using Office 2003.
View 3 Replies
View Related
Jun 5, 2013
The problem I am having is that the data I am transferring is going to top of column cell first and then when I run the macro again it skips down to the next empty cell in the column...what I want it to do is paste the data into the next empty cell...
Here is the code I am using
Code:
Private Sub CommandButton1_Click()
Dim oExcel As Excel.Application
Dim oWB As Excel.Workbook
Dim oWS As Excel.Worksheet
Set oExcel = New Excel.Application
oExcel.Visible = True '
View 1 Replies
View Related
Feb 20, 2007
I am trying to export charts to powerpoint. I have a sheet where the user gives the list of excel files and sheet names (charts as sheet) to be imported. I run a loop to create this... but then i get a script out of range error.
Sub Chart2PPT()
Dim objPPT As Object
Dim objPrs As Object
Dim shtTemp As Worksheet
Dim chtTemp As Chart
Dim intSlide As Integer
Dim FSO As Object
Dim FromPath As String
Dim ToPath As String
Set FSO = New FileSystemObject
If FSO.FileExists("\server4meme.ppt") Then
Kill ("\server4meme.ppt")
End If
Set FSO = New FileSystemObject
If FSO.FileExists("\server4me ot.xls") Then
Kill ("\server4me ot.xls").........................
View 6 Replies
View Related
May 12, 2009
I don't know if this is possible, but is there a way to have a macro in Excel copy and paste charts into a Powerpoint file? I've got a program that creates all the material needed for a Powerpoint slide deck and I want to automate the copy/paste work.
View 2 Replies
View Related
Oct 15, 2009
I am exporting from Excel into PowerPoint, and I am afraid of having a seizure after watching the export too many times. What is the best way to hide this or keep the focus on Excel?
I have tried many methods but have failed thus far. I have a modeless userform that opens up when the macro begins, but it always changes focus to PowerPoint. I have ScreenUpdating set to False.
View 3 Replies
View Related
Sep 25, 2011
I have 3 potx files, for one of them the links come out as:
Site Safety Metrics Rollup.xlsm!PPT1!R101C2:R118C14
the other are like:
C:EHS ReportsTFP EHS ReportSite Safety Metrics Rollup.xlsm!PPT1!R192C2:R209C14
I want to have the same format as the first one i.e., without the path. When the potx files are refreshed the link file will always be opened, so i do not need the path (this is part of a vba program).
The folder containing the files will be sent around and put in different drives.
'EHS Reports' is the main folder and that and everything else inside will remain the same. But the ppt links will not change so obviously will not update when the 'EHS Reports' folder is somewhere else.
Why did the links show up in different formats?
View 2 Replies
View Related
Feb 20, 2014
I have written a macro to export many bmp image files to different PPT slides. Everything works fine, but for few slides I am not able to change the co-ordinates. I am using the below code to position the image files. But no matter how much I change the values, the images sits in the same place. And I dont get any error.
PPSlide.Shapes.AddPicture Filename:=slide4pic2, LinkToFile:=msoTrue, SaveWithDocument:=msoTrue, _
Left:=475, Top:=240, Width:=245, Height:=100
PPSlide.Shapes.AddPicture Filename:=slide4pic3, LinkToFile:=msoTrue, SaveWithDocument:=msoTrue, _
Left:=475, Top:=340, Width:=245, Height:=100
PPSlide.Shapes.AddPicture Filename:=slide4pic4, LinkToFile:=msoTrue, SaveWithDocument:=msoTrue, _
Left:=475, Top:=440, Width:=245, Height:=100
View 1 Replies
View Related
Jun 17, 2014
I am having difficulty trying to access excel from powerpoint and run a VLookup. I think my problem is somewhere around the xlworkbooks.application.VLookup...(line) Herre is the code i am using below
Code:
Private Sub loginbtn_Click()
If txtUsername.Text = "admin" And txtPassword.Text = "admin" Then
frmMenu2.Show
[Code]....
View 2 Replies
View Related
Nov 14, 2008
Is there a quick was of copying lots of embedded graphs in powerpoint and pasting them into Excel?
View 4 Replies
View Related
Apr 10, 2014
I'm trying to code so that any changes made to Excel document will automatically change in PowerPoint. I have Copied and Pasted Special link so that its connected but when ever a change is made in Excel in powerpoint I get a pop up box saying I need to press update. But I want to bypass the pop up update box and have it so that powerpoint automatically updates when I change something in Excel.
This is the code I have so far. I don't know if it's right or if I am on the right track as I get a compile error saying I need a End with.
[Code] .....
View 4 Replies
View Related
Mar 31, 2009
You will find two attachements to this thread. One is a completed example I found pasting charts into PowerPoint Presentation and the other is my example of what I would like done. Difference here is that I am not using charts, instead I am using selected ranges to paste in a PowerPoint Presentation.
Instead of pasting charts to Excel, I would like to make each colored range a slide in the PowerPoint (Please see attachment).
So by click on the command button "Create PowerPoint Presentation", I would like to have PowerPoint open and the two colored ranges should be in the PowerPoint Presentation as Slide 1 and Slide2.
I have done some research on this topic and found information, but I have not clue as how to do it.
View 13 Replies
View Related
Apr 2, 2009
I have a Workbook, that I would like to copy over to an existing PowerPoint template.
The order that the sheets are currently in, is the same order I would like the presentation to be.
Can this be done all at once with command button?
see attachment for examples of the Workbook and PowerPoint template
View 14 Replies
View Related
Nov 9, 2011
How to temporarily disable PowerPoint charts which are linked to Excel. The problem is, whenever I copy a slide and try to paste it elsewhere, Office attempts to update all of the links in the entire PowerPoint. Since the slide deck has so many links, this takes an awful lot of time to do. I don't want to break the links completely as I would lose any ability to keep them dynamic. I've checked all of the advanced options within PowerPoint, but cannot find any way to temporarily disable links from updating.
View 1 Replies
View Related
