PDA

View Full Version : Read the newest file in a folder, how?



DID
2014-07-09, 08:31 AM
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
2014-10-14, 06:29 AM
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