Read the newest file in a folder, how?

DID

New member
Joined
Jan 14, 2014
Messages
15
Reaction score
0
Points
0
Dear all,

I have very difficult task to do.

We have a kiosk presentation of different data going on in an eternity from a PPT presentation. However I have a folder on the network, where there is a new Excel file created every day at 15.00h. Now I would like somehow this PPT presentation to read the newest Excel file in a certain folder (it is always in the same folder the file is created). In the folder there are only these files. The files created contains a table ranging A4:G16.

So is it possible to program a PPT presentation to read the newest (excel)file in a folder, at a certain time (e.g. 15.30), and show the table ranging A4:G16?

I would be glad for any help, or even a suggestion where I might find other help!
 

WizzardOfOz

New member
Joined
Sep 4, 2013
Messages
184
Reaction score
0
Points
0
Location
Australia
Excel Version(s)
Office 365
Insert a linked Object to a spreadsheet (e.g. linked.xls)
In linked.xls on open get the correct file and link to this e.g. a4 = [LatestFile.xlsx]Sheet1!$A$4

You could do this all with a power point macro but it's a whole lot easier in Excel
 
Last edited:
Top