asked on

Excel VBA - How to find out how create the windows folder or directory.

Hi Experts,

Can you please help guilde me in the right direction with vba coding to extract the "Author" property from a Windows directory. I need to know who created the folder that sits on a local drive.

I'm currently doing this manually as can be seen in attached image.
Thanks in advance.
Ric

dlmille

Here's an excellent tip to access file properties, including author:

http://www.codeguru.com/forum/showthread.php?t=372929

Dave

dlmille

You need to add a reference to the Microsoft Shell Controls and Automation library to use the shell objects in the getFileAttributes() function...

This gives you file properties, of course. I'm checking to see if folder properties are also available...

dlmille

I'm finding all kinds of sources listing folder properties. None of them mention author. I don't think I have ever seen it. Sorry for the question, but can you show an image of an author associated with a folder? I tried what you did on my machine and get null results.

Thanks for the clarification.

Cheers,

Dave

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ricky Nguyen

ASKER

Hi Dave, thanks for the quick reply. I wasnt expecting anyone to get back to me so quickly. Ill give your suggestions a go when im in the office tomorrow. Thanks once again.

Ricky Nguyen

ASKER

Thanks very much Dave!!