asked on

retrieve group or user names from security tab of the file properties dialog field.

Dear Experts:

I got pdf file names along with their full path in Column A of the current worksheet, such as ...
Column A
Header = Path Names
G:\Company\DMD\PM4\product_scissors.pdf
G:\Company\DMD\PM4\product_pincers.pdf
G:\Company\DMD\PM4\product_123.pdf
G:\Company\DMD\PM4\product_456.pdf
G:\Company\DMD\PM4\product_5xy.pdf
etc.

I wonder whether an Excel Macro is able to retrieve information from the security tab of the file properties of the individual files.

In specific, I would like to retrieve all the entries that are listed as group or user names on the security tab.
These entries are to be retrieved and enter into Column B, separated by semicolons.

I hope this is feasible. Help is very much appreciated.

Thank you very much in advance.

Regards, Andreas

ASKER CERTIFIED SOLUTION

abbas abdulla

membership

This solution is only available to members.

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

Start Free Trial

Andreas Hermle

ASKER

Hi Abbas,

Oh, that is great that you tackled this challenge. Will do some testing and then let you know. Thank you very much for your swift response.

Andreass

abbas abdulla

Hi,

Please mark the question as solved if the code solved the problem.

Andreas Hermle

ASKER

Hi Abbas, sorry for the huge delay in answering. I will some testing today and then let you know. Again, thank you very much for your superb and valuable help,

Andreas Hermle

ASKER

Hi Abbas, wow, I am really/truly impressed, this is just great. Exactly how I wanted it. Thank you so much. this is fantastic.

Before awarding points, what is this testfolder for?

You wrote: "The folder named "testfolder" must exist on the C:\ drive." Did you write that inadvertently or is this really necessary?

Andreas

abbas abdulla

Hi,
This comment was with the original code. which can be found in this page:
https://docs.microsoft.com/en-us/previous-versions/windows/desktop/secrcw32prov/getsecuritydescriptor-method-in-class-win32-logicalfilesecuritysetting

I just amended some parts of that code.

Andreas Hermle

ASKER

ok, great,

Andreas Hermle

ASKER

Ftantastic abbas, this is really a great job from you. I really highly appreciate it.

Regards, Andreas