Details of Files

In your world, who is the owner of the file? Created by? Last modified by? Author in the Properties?

I've used this code which is brilliant !!

Does anyone know what I need to add to be able to get the file owner.

Thanks

Hello Andy,

This macro will give the owner and lot more information about a file and its folder. This macro returns a User Defined Type (UDT) structure that holds the information. The advantage of this is easy referencing of the data. With UDTs VBA applies Intellisense which displays the drop down list of properties fro the UDT. You must set a reference in you VBA project to the Microsoft Shell Controls and Automation library for this macro to work.

Please Login or Register  to view this content.

Example of Calling and Using the Macro

Please Login or Register  to view this content.

Setting a Reference in VBA

1. Open your workbook and then press ALT+F11 to open the VBE.
2. Press ALT+T followed by the Enter key.
3. Scroll down the list until you find Microsoft Visual Basic for Applications x.x Object Library.
4. Press the Space bar to select it, and press Enter
5. Press CTRL+S to save the reference in the project

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Threads merged.

My preference:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

If you want to know the author:

Please Login or Register  to view this content.