Open a linked object(word,excel) using VBA and save.

  • Thread starter Thread starter Prasanth
  • Start date Start date
P

Prasanth

Hi all,

I have a problem with my vba application, I need to update the link in a
presentation(ppt). I used the
updatelink method to update the linked object. in my case ppt is linked to a
word document and in the
word document data is filled from a access table. Here the ppt is not
refreshing the word document the change in database is not
reflecting in the presentation.

But I tried manually it is working, click the object in ppt then word
document will open with refreshed data from table
and when closing it prompt to save the document ,I save it then our ppt
object will refresh with new data.

Anyone please tell me a method to solve this multiple link.

Thanks in Advance
Pt
 
I have a problem with my vba application, I need to update the link in a
presentation(ppt). I used the
updatelink method to update the linked object. in my case ppt is linked to a
word document and in the
word document data is filled from a access table. Here the ppt is not
refreshing the word document the change in database is not
reflecting in the presentation.
Click to expand...

You're refreshing the link from PPT to the Word document, but apparently
nothing's telling Word to refresh the link to the database data. You'll
need to automate Word to do that as well.
 
Hi,

Thanks for your replay.

I need to open the linked document object in the power point slide, then
save and close the word document.This all will be
automated by my VBA in access.I can able to open the linked document using
the code
like
ppt.ActiveWindow.View.GotoSlide oSld.SlideIndex
oShp.Select
oShp.OLEFormat.DoVerb Index:=2

but i can't save and close the opened linked document object.I cannot get a
handle to this opened object.
Please tell me another method to save and close the linked document object
from a VBA.

I expect a replay.please mail me.

Thanks
Pt
 
Back
Top