Kenneth,
A million thanks for the code you are sharing in your #16 post. I tested out your code and I made sure to start with a clean worksheet as you instructed. In cell C7 I entered the PATH for the top level folder containing my music video collection. Then I hit the RUN button in the Macro Dialog window and I got the following error:
"Compile Error: User Defined type not defined"
(I have attached the XLSM file I am trying to make work)
The code stops working in area "C" indicated in the screen capture below. I tried tweaking the code to see if I could get it to work but I have to admit I still don't understand all of the levers and gears relating to your code. I have a general idea, but not enough to fix it on my own. Below I have posted a screen capture of your code highlighted with Letter Identifiers.
In addition, what I'm still trying to understand is what I need to do to your code so that I can make it fetch any of the other 42 property details you mentioned.
I am assuming the following:
"G" = fetches PATH data and places it in Column A
"H" = fetches NAME data and places it in Column B
"I" = fetches SIZE data and places it in Column C
"J" = fetches DATE LAST MODIFIED data and places it in Column D
"K" = fetches DATE as a number format and places it in Column E
"L" = Has me confused because my Windows Explorer shows it as LENGTH
Could I now correctly assume the following?
If I want to add FRAME WIDTH & FRAME HEIGHT I will need to add these new lines of code -
[vba]
Cells(iRow, iCol).NumberFormat = "frame width"
iCol = iCol + 1
Cells(iRow, iCol).NumberFormat = "frame height"
iCol = iCol + 1
[/vba]
If you could clarify this for me I would appreciate it. Again, a million thanks for your generosity in developing a very cool File List Generator. I think it's going to be light years ahead of the List Generator I attached in my #1 Post.
Reply With Quote