update links in powerpoint with VBA - Microsoft Community

good afternoon,

i trying update presentation while in kiosk slideshow, updates of data shown on screen.

this data generated in excel file, every 5 minutes. best solution presentation updates every 5 minutes.

so far have been unsuccessful, due conflicts between excel , powerpoint trying access same file.

how runs now:

excel file one, log, uses vba send data data sheet in separate excel file.

powerpoint uses add-in update entire file when 1st slide opens again.

while trying have powerpoint if file available have come far:

sub update()
dim xlapp object
dim xlworkbook object
set xlapp = createobject("excel.application")
xlapp.visible = true
if xlapp.workbooks.open("i:\oee\testbestand\presentatie\test.xlsx").readonly = true then
msgbox ("read only")
else
msgbox ("niet read only")
end if
xlapp.workbooks.close
xlapp.visible = false
end sub

this works, when change msgbox in not read to:

 application.presentations.updatelinks or activeaplication.updatelinks

it doesn't work.

also want macro run every given time period, hope use similar macro use in excel.

i tried making making separate file shared, powerpoint still can't update.

with kind regards

edwin

share workbook.

1. in excel, on review tab, in changes group, click share workbook. 

2. in share workbook dialog box, on editing tab, select allow changes more 1 user @ same time. 

3. close dialog , save workbook.

4. close workbook.

now both powerpoint , macro able access workbook without hitting read-only errors.

Office / PowerPoint / Microsoft Office Programming / Office 2016