+ Reply to Thread
Results 1 to 4 of 4

POWERPOINT update links to Excel

  1. #1
    Registered User
    Join Date
    08-02-2010
    Location
    UK
    MS-Off Ver
    Office 365 Home
    Posts
    39

    POWERPOINT update links to Excel

    Hi there,

    Possibly not the correct place to pose this question as strictly its PowerPoint VBA, but I'm hoping the issue is simple enough that someone here might be able to help.

    I have an Excel spreadsheet that produces and updates graphs. These are copied into a PowerPoint that is sent to a client. When they receive the Excel + Powerpoint the links are broken because they reference directories on my PC. I am trying to automatically edit these links with VBA before I send the PowerPoint so that they reference a non-existent directory on my end, but accurately reflect the directory on the client end.

    Currently the script I have is causing a Run-time error -2147188160, which I understand from this link https://support.microsoft.com/en-gb/...ntation-call-i requires a piece of additional VBA to ensure the application is visible (the PowerPoint would be running and visible when the script to change the links is run, but anyway). I've tried to add the recommended code, but still get the Run-time error -2147188160 error.

    I have the following references running:
    • Visual Basic for Applications
    • Microsoft PowerPoint 16.0 Object Library
    • OLE Automation
    • Microsoft Office 16.0 Object Library
    • Microsoft Excel 16.0 Object Library
    • AutoEvents
    • FM20.dll

    Any and all help greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: POWERPOINT update links to Excel

    You're right about the location - I've moved it to the correct sub-forum.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-02-2010
    Location
    UK
    MS-Off Ver
    Office 365 Home
    Posts
    39

    Re: POWERPOINT update links to Excel

    Moving a question to this sub-forum is tantamount to chucking it in the bin.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: POWERPOINT update links to Excel

    No, it isn't. It's the right place for it, but we hardly ever get questions about PowerPoint - I can't remember the last time - and I suspect that nobody feels au fait enough with the topic to be able to offer you support. That's the way it goes sometimes - sorry.

    As a gesture of goodwill, I'll move it to the Excel VBA forum to see if it gets a bite there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  2. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  3. User Form - in Powerpoint - Update Links from Excel
    By gastonpresente in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2015, 09:36 AM
  4. [SOLVED] Update powerpoint links from Excel
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 05:18 AM
  5. How to dynamically update links based on data (not Cells) in PowerPoint via Excel?
    By pats2kdynasty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2012, 01:10 PM
  6. VBA Code to update powerpoint links
    By Mukesh Sajjan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2011, 05:24 AM
  7. Update Links in PowerPoint from Excel
    By cassy01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2007, 06:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1