Hey everyone, i am currently creating a file directory (files from a folder) in excel through a macro. I found a code online which i tried to adapted to my needs as much as i was able to. The macro provides me with a list of file names, paths, size, date created, last date used and a hyperlink to the file. So my basic need is satisfied by this code but the issue is the window that pops up when u activate the macro: from the starting folder onwards (which i indicated in red in the code) u cannot go to higher levels, for example to the Desktop so i'm blocked in the C:\ drive. It is only possible to go into subfolders of C:\. I would like something like a basic Windows explorer window, meaning something that allows me to navigate to all folders i want.
trying to get such a window, I included this: Call Shell("Explorer.exe C:\", vbMaximizedFocus) below the "On Error Resume Next"
but this explorer window that pops up doesnt allow me anymore to get a directory in excel with name,size,etc...
The code looks as follows:
I hope i explained my problem in a way that you understand what the issue is and i would be very thankfull for any advice!
KoalaMAx
Bookmarks