There is a really complex way to do this involving trying to find the security information, which is an array of values that will give you the SID of the file owner. OR... there is the backdoor method that might or might not work for you.
Purists will try to use a WinAPI call to get the security information for a file. Here is an article that might help you.
I am very new to vba and I was tasked to make a list of the files in a given folder as well as the users with permissions for every file. I was able to get the filenames in the folder, but I don't...
stackoverflow.com
The "backdoor" is actually more convoluted but gives you everything you need in one place. Consider spawning a shell with a command prompt. Send through two commands:
CD {some-folder-name-of-interest]
DIR /Q > {some file name}
Then open the "some file name" that was output by the redirection (the ">" symbol redirects program output to a file). That will give you a list of files in the "some-folder-of-interest" folder along with their dates of creation, "<DIR>" if the file on that row is a directory, the numeric file size if NOT a directory, the file owner NAME, and the file name & type. You could parse that out because the DIR command makes those fields always align, i.e. fixed width. Should be easily parsed with just a little bit of attention to columns. Try it manually yourself to see what the output looks like because you will see that it will give you pretty good alignment of the columns in question.
You would have to read several lines looking for something that says "Directory of {some-folder-name-of-interest}" after which you would skip one (blank) line and start reading the directory contents. Once you are in the directory area, the next fully blank line is the end of the folder list.
