Excel - PowerPoint linking Problem

L

Loopi

Not sure how or where to apply the Application.Run method:
In my excel workbook I have this code in the ThisWorkbook Object:

Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("01:00:00"), "UDLink"
End Sub

UDLink macro is as follows in Module 1:

Public dTime As Date
Sub UDLink()

Application.DisplayAlerts = False

dTime = Now + TimeValue("01:00:00")

Application.OnTime dTime, "UDLink"

Sheets("Rotation Breakout").Select

ActiveWorkbook.UpdateLink Name:= _
"X:\0108 Production Reports.xlsb", _
Type:=xlExcelLinks
ActiveWorkbook.UpdateLink Name:= _


Application.DisplayAlerts = True
End Sub

This all works fine every hour. However I need powerpoint to updates its
links to this excel file shortly after excel finishes with it's updates

What I need is to execute the code below which resides in the presentation.
Lost - VB Loser here!!!!!!

Sub UDL()
ActivePresentation.UpdateLinks
End Sub

Both the spreadsheet and powerpoint presentation are open at all times. I do
not know the proceedure to call powerpoint routines in excel macro's

Thank you for any help you can provide
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top