I'm trying to get a list of all the files and folders (with the path name) and the date the file was last amended, please?
I've found the enclosed code which gives a list of the files with the path, but I wonder is it possible to dictate a particular starting location, rather than just starting at "Desktop"? Although I can sometimes copy, paste and amend bits of VBA to achieve what I need, I can't "see" how to do it in this..?
I'd also like to see the date the file was last amended, please - we use several files each day, so this serves as one of the checks to check whether the files have been updated. I'd prefer the date to be listed in a separate column - e.g. file name and path in column A, date in column B. If it's possible to split the folder into one column and the filename (with extension) in a separate column, that would be perfect!
Can anyone help, please?