Preventing "Update Links" dialog in PPT

[jaya]

I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?

I use office 2002...

Thanks.
JayG

 

[Steve Rindsberg]

I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 

[Guest]

I would like to do this VBA and while opening the ppt...

-----Original Message-----
I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

.
[/QUOTE]

 

[Steve Rindsberg]

I would like to do this VBA and while opening the ppt...

It might need to be done to the file before opening it.
You can set a linked shape's .LinkFormat AutoUpdate property to
ppUpdateOptionManual I think but by that time, there's already a messagebox
asking what to do about links.

A couple of things you could try as workarounds:

Open the presentation w/o a window
or
Open the presentation, then iterate through open windows looking for the
"Update Now?" dialog and send it keystrokes to close it immediately. Ugly.

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

.

[/QUOTE]

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================