How to get the owner name & Last modified user details from excel file path.

[Kottapally_Ramesh]

Hi,

I need to get the owner details & Last modified user details for bulk excel file paths.

Is there any way.. ? I have tried directory tool and command tool but it's not working.

[patrick_mcauliffe]

You'll have to do this on an individual file basis (so probably best to build a macro for bulk).  

Here's how:

Using a data input tool, set the path to a specific Excel file, then change the file type in the Input tool to Zip.
Then going back up to the line where you would usually select an Excel sheet, click that and it should generate a list of xml files.   The one you want is located in /docProps/core.xml