Change Links In PowerPoint - MSGraph - Excel
Hello! I have a embedded MSGraph object in a PowerPoint slide, linked with a Excel worksheet. I want change the link to a new source Excel file.
Can someone help me?
Thanks in advance.
Greetings, César González.
PD:
The msoLinkedOLEObject has the property '.LinkFormat.SourceFullName',
I am looking for the equivalent property of the 'msoEmbeddedOLEObject'
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Powerpoint MSGraph Datasheet Link
I'm trying to break a link programmatically in VBA for Powerpoint. This is not a linked object itself. The chart is MSGraph and the datasheet is linked to a worksheet in Excel. It's simple to edit the graph and select "links" and "break link" from the menu, but I've got hundreds of them to do so I'm trying to figure out how to do it programmatically. I can see the "haslinks" property of the msgraph application object is set to true, but I can't figure out how to unlink it. I can't see any of the link information (application, sourcename, etc.) when I try to watch the object so I'm stumped as to how to do this. Any suggestions? Thanks.
Powerpoint - Break All Links
I am trying to make a macro that will find and break all the links in a Powerpoint presentation.
I am new to vba and have cobbled together this effort, which unsurprisingly doesnt work, but hopefully you will see what I am trying to do:
Code: For Each oSld In ActivePresentation.Slides
For Each oShp In oSld.Shapes
oshp.LinkFormat.BreakLink
Next oShp
Next oSld
HYCH
Exporting MSGraph To Word-Excel From Access 2000
Hi,
1. I've created a Form with the graphic wizard.
2. I'm trying to export it to Word or Excel
3. Access only exports the data table but not the graphic
Is there a way to do this? Please!!
PDexcuse my english)
Can You Change What Database File A Dataenvironment Links To?
I am writing a program in VB6 and I have it creating a project folder where it copies an empty database into that folder using the project name as the database name. I need to have my dataenvironment look at that file once it is created but I cannot figure out how to change what it is linked to. I am using vb6 and MS Access
Any help would be appreciated!!!!
Change Colour Of PowerPoint Text Box In VB
Hi
I use the following code to insert an image into a PowerPoint slide with a text box for a title. I am trying to colour the background of the text box to white.
VB Code:
With ppPres Set ppSlide = .Slides.Add(.Slides.Count + 1, ppLayoutBlank) 'Add a new slide With ppSlide ppSlide.Shapes.AddPicture FileName:=picLocation, LinkToFile:=False, _ SaveWithDocument:=True, Left:=0, Top:=0, Width:=703, Height:=538.38 'Add image to slide Set ppShape = .Shapes.AddTextbox(msoTextOrientationHorizontal, 0, 0, 720, 50) ' Add title box With ppShape .Fill.BackColor.RGB = RGB(0, 255, 0) 'HERE With .TextFrame.TextRange .Text = "TITLE" 'Set title to TITLE With .ParagraphFormat .Alignment = ppAlignCenter 'Align title to centre End With With .Font .Name = "Arial" 'Set title default font .Size = 18 End With End With End With .Select End With End With
I cannot see why the line
VB Code:
.Fill.BackColor.RGB = RGB(0, 255, 0) 'HERE
does not work. Does anybody know why? Do I have to turn some default off for the change to take effect?
Thank You
Powerpoint - Change Color Of Shape From CommandButton
This is a pretty simple application but I can't get it to work...
I'm trying to change the color of a shape when a command button is clicked.
I have the following sample code
Code:
set FillThisObject = ActivePresentation.Slides(#)
FillThisObject.Shapes(???).Fill.BackColor = &OCO&
I can't determine the shape index for the shape. How do I determine ??? I tried using a macro where I can change the name of a shape once highlighted but that didn't work either.
Is .Fill.BackColor wrong?
I haven't used VBA in a year so it's relatively cloudy, thx for the help
patrick
Powerpoint: Removing Shapes On Slide Change
I dynamically add a few shapes to a Slide to simulate a dropdown menu. I ran into a problem deleting the shapes again however.
Because I write shapes they are actually added to the slide and won't disapear anymore. I know how to dynamically delete a shape. That is not a problem. But I want to do this when the user goes to the next slide. I could unfortunatly not find any event that is triggerd upon moving to a next slide. Is this at all possible? Am I simply missing something?
In the ideal situation the user would click on a "menu item" (a shape), which opens up the dropdown menu (a collection of dynamically writen shapes) and when the user clicks anywhere but the dropdown menu all those shapes making up the dropdown menu would be deleted again.
I have no problem detecting my dropdown menu, nor with deleting slides. I am most of all looking for an event or any other possible way to trigger my code when the user clicks to go to the next slide.
Thanks in advance to anybody who can help me!
Excel 2000, Create Powerpoint Org Chart From Excel.
I want to create a powerpoint org chart from Excel using information held in Excel. I have found how to add an Org chart into Powerpoint but can't find anywhere that tells you how to change the details/options or add Subordinates Managers etc and alter those details.
Anyone have any ideas (I don't want to create seperate text boxes if possible.)
Ps if you can create a good powerpoint org chart from excel, any ideas on the best layout of information in the spreadsheet to work through and create it.
This is one of those, that would be good if you can do it (created them in the past and are time consuming pains), rather than has to be done last week ideas.
Regards.
rob.
VBA & Excel Links
I have several workbooks that are linked. They are located in a subdirectory. The problem is, when I copy one of them to another location or to another drive Excel references the links back to the orginal location.
Is there a way to have the link references point to the new location?
Excel Links
does anybody know if there is a way to tell if somebody has set up a link to one of my excel files.
Excel Links
Hi all,
I am trying to update somelinks in a piece of code. It works fine for individual links (Reuters, Bllomberg etc).
What I am having trouble with is figuring out how to update a link to another file:
I can use ActiveWorkbook.UpdateLink Name:="".....but I don't know how to refer to the link..
Does anyone know how I can get the name of the link....sounds silly i know but it's baffling me now.
Thanks in advance
Links From Excel To Word
I have created a crude Word doc as a test. I have manually cut and pasted a link from an excel spreadsheet.
When the link in Word updates it always puts carriage return before and after the link.
So when i have some text in word such as
Sub Total :
<result of link>
it always ends up putting it on the next line down. I have tried various options of destination formatting.
Is there anyway I can have such a link and keep the results on the same line when looking at cells in Excel??
Thanks in advance
Removing Excel Links
hello, I have this bit of code that removes unwanted worksheets for the client to view. There are also Links in the workbook that causes a update links screen to appear.
I can't seem to figure out how to get rid of them so that screen doesn't appear when the client opens the workbook. If anyone has any ideas or could point me in the right direction that would be great.
Thanks in advance,
art
Word-Excel Links
Hello I was wondering if it was possible to create links between Excel and Word, lets say to have a word doc fillied by the data of exel,
Thanks
Excel - Update Links
Okay guys, I got a really fun one for you here.
I have a summary workbook that is linked to individual detail workbooks. Each of the detail workbooks are password protected. Whenever you update information on the summary workbook, you have to input the passwords for each of the individual data workbooks.
How can I avoid this? I was thinking of using some type of before_calculate event, but I can't seem to find one.
Any ideas?
Excel To Word Links
I have created a crude Word doc as a test. I have manually cut and pasted a link from an excel spreadsheet.
When the link in Word updates it always puts carriage return before and after the link.
So when i have some text in word such as
Sub Total :
<result of link>
it always ends up putting it on the next line down. I have tried various options of destination formatting.
Is there anyway I can have such a link and keep the results on the same line when looking at cells in Excel??
Thanks in advance
Excel File Links
I am writing some simple VBA code to open some files. All of the files have links to other files which is not a problem. However, some of the files have link to files that contain passwords to open them so I am getting a bunch of messages which I must hit "cancel" to continue. Is there a way to code around this situation? I would like to keep updatelinks:= 3 so the other 99% of the files have the most updated data in them. TIA
Excel - HTML Links
I'm working on a software package (created in Excel and VB). An HTML web site has been created.....i've programmed everything else but can't seem to call up a page from an HTML web site (in Net Objects Fusion)...
Is this amazingly hard or have i been staring at VB code for far too long?!!!
Could someone please let me know how the process of finding and locating the path and then displaying the page?
Invisible Excel Links
Automating Excel, I get with the 'Linksources' method in VBA a reference to links which are invisible with the 'editfind' function in Excel and should be links that should not exist anymore. Can anybody give me a tip how to kill these persistent links?
Excel - Update Automatic Links Pop-Up
I have an excel file that contains macros and links to other workbooks. When someone goes to open this file, my boss doesn't want the "This file contains macros. Enable/Disable" or the "This workbook contains automatic links. Update now?" pop-ups to show up. I read on the forum about using a digital signature to get rid of the enabling macros pop-up. Is there a way to get rid of the "Update Automatic Links" pop-up?
Thanks!
Finding Cells With Links In Excel
Heyas
Anyone know how I can run through a workbook in Excel 2k and test each cell if its value is a link to another workbook??
Have broken links and the file is too big to find it.
Deleting the links is the last option
If I could somehow findthe initial 2 chars of the link function ie =[
Then I think Im half way there but how can I compare a function syntax instead of the actual value visible in the Cell??
Many thanks for any insight
CandyMan
NEVER MIND
If Left(CStr(ActiveCell.Formula), 2) = "=[" Then
MsgBox "Match"
End If
Can start with this...
Refresh Links In An Excel Workbook Using VB
Hi!
I have an Excel workbook with some worksheets, each of them contains data that comes from a query (which was written using MSQuery). The worksheets are linked to the query!
I need to write a VB program that opens the workbook and refreshes the links. I tried to do that in so many ways, but all of them failed. Even when the program finished to execute without run-time errors, when I opened the workbook with Excel, I found that the workbook was not upgraded at all!
So far I have tried to use "Workbook1.RefreshLinks" and "Workbook1.Worksheets(1).Selection.QueryTable.Refresh" with many more variations on them.
Does anyone know another way to do that?
Thanks!
Excel - Automatic Links - Turn Off
I have a spreadsheet on a network at work that links to 6 different spreadsheets. I know you can turn off the question for updating the automatic links manually. I have found that it depends on each users own Excel settings.
I am curious to know if there is a way during start-up to have the question not asked to update the links regardless of what the user's personal settings are, while still updating.
I assume, if this possible, that it would have to be done in VBA code.
Any help would be greatly appreciated.
How To Identify Excel Documents Containing Links?
Apologies if I have asked this question in the wrong forum.
I have a large number of documents stored on a network share. The documents are being migrated to another location and I need to be able to identify any excel documents that contain links to other workbooks so these link documents can be excluded from the migration.
Is there a tool that I can use to identify these documents quikly?
regards
damien
Play Links From Excel File
I?m new to vb, looking for ideas on how to play links from execl files .
It would get list from file and play them together,, Ex display a text file with a picture file along with sound file.
Prevent Excel Links Being Overwritten
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveSheet.OnEntry = "Checklink"
End Sub
=============================
Sub Checklink()
'Uses two named cells. One is named "title" and the
'other is named "titlecheck" i.e. the same name with "check"
'added
'the formula in the second cell reads "=title"
'Any entry in this cell therefore will overwrite
'the link. This procedure prevents this and also
'passes any entered value back to the other cell
'and maintains the original link.
With ActiveCell
cn$ = .Name
nm$ = ActiveWorkbook.Names.Item(RefersTo:=cn$).Name
nm$ = Trim(nm$)
nl% = Len(nm$)
'check that cell name ends with
'the word "check"
If nl% < 6 Or LCase$(Right$(nm$, 5)) <> "check" Then
Exit Sub
Else
norm$ = nm$
wiz$ = Left$(nm$, nl% - 5)
nufrm$ = "=" + wiz$
End If
cf$ = .Formula
cv$ = .Value
' Format cell as "General" if
' currently "Text"
If Selection.NumberFormat = "@" Then
Selection.NumberFormat = "General"
End If
Range(wiz$).Value = cv$
.Formula = nufrm$
End With
End Sub
Programatically Remove Links Within Word To Excel.
I have a word document that has content linked to some
cells in excel. by that i mean, i copied from excel and
did a paste special with links. I can manually break these
links in word if i go to edit -> links and break all the
links. Is there a way of doing this through a macro. I
tried recording the link breaking procedure but nothing
showed up in the macro. The word vba help has an example
of where it shows how to break links but that seems to
work only for objects and not text.
thanks in advance
Poorav
Programatically Remove Links Within Word To Excel.
I'm opening XLS and CSV files in VB for batch processing. One of the files has links to another XLS file, and it prompts me with a links questions every time I run the batch.
I cannot have an admin sitting there to answer the question, so how do I surpress the message or break the link?
I've tried to break the link, but that requires opening the files first, and that gives me the message prompt.
I've already tried this.
xlApp.DisplayAlerts = False
Any ideas?
Thanks in advance!
Excel 200, Stop Links Message & Update.
I have a spreadsheet with links to an external source. Is it possible to not display the Update Links message on Opening and to Not update the links.
I have seen code to turn off the Update links message but this then automatically updates the links which is no good.
The spreadsheet is being sent to people who won't have access to the base information, so will delete all data if user presses wrong button etc.
Don't think this is possible but any help given is much appreciated.
Regards.
rob.
Suppress Update Links Window In Excel
I am trying to suppress the update links window in Excel and want to select the default value of yes. I have seen code where you turn off display alerts, open the file then turn the alerts back on. I don't think that will work for me because i want to do all of this within a single file (the file that has the links). I have also tried toggling the Application.AskToUpdateLinks property to False but that does not seem to work. It seems that it wants to update the link before the Workbook_Open code runs.
Can anyone help?
Suppress Automatic Links Message Excel VBA
When opening an excel workbook bia VBA I always get a messagebox prompting the user that the sheet has links to other files adn do they want to update the links automatically or not? Is there anyway of stopping this prompt from appearing?
Wait For Excel DDE Links To Update Before Moving On
I have created a number of DDE links from my Excel spreadsheet into WinTV's teletext (VTPlus) which I am using launch the spreadsheet. Once opened the spreadsheet updates the links and then recalculates some VLOOKUP formulas before doing a "copy/paste as values" to save the data. Once this is done the spreadsheet will save and close. It runs a bit like this.
1. Launch VTPlus32.exe
2. The macro in VTPlus32 opens 30 teletext pages and waits while the pages are updated.
3. Launch MySpreadSheet.xls
4. Wait for the links to update, wait for the calculates - THEN copy data to somewhere as values.
This is the bit I'm struggling with.
How can I make my macro pause but still allow the links to update? I've tried WAIT, DOEVENTS within a loop, I've even tried recalculating each link within a loop but to know avail.
This is the code in my macro
'Update Links
alinks = ActiveWorkbook.LinkSources(xlOLELinks)
If Not IsEmpty(alinks) Then
For counter = 1 To UBound(alinks)
ActiveWorkbook.UpdateLink Name:=alinks(counter), Type:=xlOLELinks
Next counter
End If
'Wait for everything to update
Application.CalculateFull
While Application.CalculationState = xlPending
DoEvents
Wend
'Copy Column
Range("C6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Insert Shift:=xlToRight
Range("B6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("C6").Select
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Looks nice - but doesn't work! It just goes straight through to the 'Copy Column bit without waiting.
I'd grateful for any help or advice.
Excel-Pivot Tables Copy Without Links
Hi
I have a workbook with many spreadsheets and pivot tables in it.
I need to make a copy this workbook with all the data/formulas/pivot tables/formatting, but without being linked to this original sheet.
Can anyone Please tell me an easy way to do this.
Paste Special does not seem to work with pivot tables.
Thank you
Excel Automatic Links Updates Do Not Work.
In Excel there seems to be no way of automatically updating a link if the source for the link is NOT already open in excel. My solution was to write a VB macro to periodically scan all links as follows: Q. Is there a more elegant way to do this.
Sub Auto_Open()
Label:
Dim PauseTime, Start, Finish, TotalTime
PauseTime = 5 ' set duration.
Start = Timer ' set start time.
Do While Timer < Start + PauseTime
DoEvents ' Yield to other processes.
Loop
Finish = Timer ' set end time.
TotalTime = Finish - Start ' Calculate total time.
'Update all links now
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
GoTo Label
End Sub
Excel To Powerpoint
I'm trying to take Excel data and put it into a powerpoint chart(graph) datasheet slide? How do I do this
For example: I want to take a list of numbers in excel spreadsheet and one by one put those values in a bar graph in a powerpoint slide. I want to put those values in a powerpoint datasheet. From those values you get a nice bar graph.
Thanks
Powerpoint In Excel
Does anyone know if it's possible, using VB, to display a powerpoint presentation within Excel - ideally within a user form. Can't seem to insert it within the form.
Alternatively, displaying it somewhere within the current WSheet would also be as useful.
Thanks
Chris
Powerpoint PPs From Excel ????
I need to open a powerpint pps file from an application in Excel, I tried using the following:
Dim ppApp As PowerPoint.Application
Dim prsPres As PowerPoint.Presentation
Set ppApp = New PowerPoint.Application
Set prsPres = ppApp.Presentations.Open(ActiveWorkbook.Path & "Distingos.pps")
But, then I realize that this code works only with Office XP, because the Office that we use is 2000 and an error is diplayed:
Compile Error
User Defined type not defined
I need help, does anybody knows how to make it work?, did I need a class module?
Excel/Powerpoint
Hi
I'm making a VBA thing which is supposed to:
paste data from several Excel workboooks into one central workbook with about 70 worksheets.
Each sheet contains an embedded graph which is linked to the pasted data.
That's the easy bit.
What I need to do now is to copy each of the graphs into a Powerpoint presentation, one graph per slide.
So,I've got code that in Excel goes to sheet 1, copies the graph, starts a new Powerpoint session, opens the PPT, goes to the correct slide, pastes the graph, then saves and closes Powerpoint, leaving Excel as the active window. Then the next sheet is selected and the process is repeated What I want to be able to do is to return to Excel, go to the next sheet etc, without having to close Powerpoint after each paste.
Can anyone advise?
Thanx
Excel To Powerpoint
Greetings y'all
Does anyone know of a way to update a chart and install it on a powerpoint slide programmatically?
I have created the charts, but the data (which comes form an external source) must be updated often. No problems there wrote code to get that done. Maybe not the most efficient code, but it works. Once the data is updated on the charts I need to be able to update the Powerpoint slide.
The big issue is the charts are one time things and the same spreadsheet is used to create all the new charts.
Would a work-around for that be creating a "buffer" spreadsheet and updating the data there. From there if the chart were linked into Powerpoint you could just refresh with the new data.
If that is the case, all I have to do is reference the buffer worksheet, findo out if the chart name exists already and overwrite or create. Then refresh or create Powerpoint slide.
Confused yet? The above brings me to my next question: Can you update a workbook even though it is not openned? If so how?
I appreciate any crazy ideas that may help.
Excel-powerpoint
Is it possible to open a powerpoint show/presentation from excel?
I want to be able to open the show as part of a help file, if the user presses a button.
MS Excel -> MS PowerPoint?
I've been trying to open a ppt file from Excel with little luck, too many error msgs! Is it possible or is it quicker and easier to go through MS Access.
I've been using code similar to:-
Dim channelNumber As Integer
channelNumber = Application.DDEInitiate("powerpnt", "H:homepowerpointpptTest1.ppt")
But it produces a type mismatch error and then a run-time error - object-defined error
Cheers
Fossil
Driving PowerPoint From Within Excel Using Excel VBA.
Hi Everybody
As we all know that we can drive one MS Office application from another, for example we can drive MS Access from within MS Excel and vice versa, what I want to know is that is it possible to drive MS PowerPoint from within Excel using Excel VBA?
I want to be able to insert graphs as pictures in to PowerPoint presentations from MS Excel (the graphs actually get created in an Excel spreadsheet and needs to be brought in to PowerPoint for a presentation - there are about 150+ of these pictures and this process needs to be repeated every month).
So I was wondering if I could automate the process of bringing in these pictures from Excel in to Powerpoint using VBA. If yes,, that would save us a lot of time and effort.
Can someone point me to wherever I can find some information to drive PowerPoint from within Excel using Excel VBA to carry out the above task?
Best regards
Deepak Agarwal
|
TRACKER
