Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Excel - PowerPoint linking Problem


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Excel to Powerpoint John Moore Excel Discussion (Misc queries) 2 November 6th 07 09:40 PM
Excel 7 to powerpoint 7 - embedding graphs but not linking Manda0812 Excel Discussion (Misc queries) 0 July 23rd 07 07:58 AM
Linking powerpoint chart to excel pooja Excel Discussion (Misc queries) 0 September 6th 06 04:20 PM
Linking Excel to Powerpoint across the net? Edward Owen Links and Linking in Excel 1 June 21st 06 11:40 PM
Linking Several Charts to a PowerPoint Presentation Rich Links and Linking in Excel 0 April 2nd 05 10:02 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"