+ Reply to Thread
Results 1 to 2 of 2

Excel closes when it open, after update excel objects on Powerpoint

  1. #1
    Registered User
    Join Date
    03-22-2020
    Location
    Colombia
    MS-Off Ver
    Office 365
    Posts
    18

    Question Excel closes when it open, after update excel objects on Powerpoint

    Hello Everyone,

    I have an excel file and a presentation on powepoint that has almost 100 excel objects linked from the excel, both has to be shared to other PC, but the presentation doesn't update the links in the other PC, so I adapted a macro in Powerpoint to update automaticaly the objects, it works. however, if the Excel isn't open before execute the macro the process is slow because it open and close the excel each time it find an object linked, and then, when it finished, if I try to open the excel, it close suddenly, so basicly I lost the excel file, doesn't matter the way to try to open the excel, It closes.


    in the macro, the method pptPresentation.UpdateLinks is out to the for cycle. (this is one thing that I don't understand, why it open and close the excel file a hundred times if the method only run one time)
    I adapted the macro from this stackoverflow.com/questions/56627694/new-drive-mapping-for-powerpoint-linked-objects-vba-solution

    How can I prevent it? different to the obvious answer, have had the excel open before execute the macro.
    or exist a way to recover the excel after that?

    I'll appreciate your help.

  2. #2
    Registered User
    Join Date
    03-22-2020
    Location
    Colombia
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Excel closes when it open, after update excel objects on Powerpoint

    I solved it,

    I just put into the sub workbook_open
    ThisWorkbook.Application.Visible = True
    Windows(ThisWorkbook.Name).Visible = True

    to force excel to open and visualize the worksheets.

+ 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. link excel objects from server to powerpoint
    By anton1234 in forum Excel General
    Replies: 1
    Last Post: 08-21-2017, 06:43 AM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  4. [SOLVED] Preserve objects when excel closes
    By Westfield in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 04:29 PM
  5. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  6. [SOLVED] [Qry] [OT] After open Excel 2K3 it closes immediately
    By Jaisol in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 12:25 PM
  7. excel closes when trying to open certain files
    By SMY in forum Excel General
    Replies: 4
    Last Post: 02-25-2005, 07:06 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