Results 1 to 2 of 2

Thread: Read the newest file in a folder, how?

  1. #1

    Read the newest file in a folder, how?

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Excel Version
    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 by WizzardOfOz; 2014-10-14 at 06:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts