File

[Andy Teal]

Hello,

 

[Gasman]

I still use the command window for stuff like that.

dir *.accde > accde.txt

Then open the file in notepad. If you use a csv extension, then it would open with Excel.
Otherwise I would likely use Dir() and add each file to an excel sheet with VBA.

 

[Andy Teal]

I still use the command window for stuff like that.

dir *.accde > accde.txt

Then open the file in notepad. If you use a csv extension, then it would open with Excel.
Otherwise I would likely use Dir() and add each file to an excel sheet with VBA.

thank you so much for your feedback. I was just wondering if there was a simple way of capturing the results in the file Explorer, as is, into Excel. "Copying as path," does not include the additional info. such as size, last modified, etc.
"Copy"ing the results, it copy the files as they are and not just the list.
So, not using the cmd window, and not using snip, no need the image, is there anyway we can capture the list from file explorer into Excel?

 

[CJ_London]

Use fso

see this link for an example

Size property (FileSystemObject object)

Office VBA reference topic

learn.microsoft.com

 

[KitaYama]

Easier way? I don't promise but
many years ago I used Excel to have a list of my music.

Check FILE function in excel. I have not used it in centuries.

 

[Isaac]

Check FILE function in excel. I have not used it in centuries

?? I have none.

 

[KitaYama]

?? I have none.

I don't have access to Excel (midnight here).
Check this:

Excel function to list files in a folder without VBA - Excel Off The Grid

Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas. I could tell you to turn to VBA macros or

exceloffthegrid.com

 

[KitaYama]

@Isaac Check this

 

[Isaac]

I don't have access to Excel (midnight here).
Check this:

Excel function to list files in a folder without VBA - Excel Off The Grid

Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas. I could tell you to turn to VBA macros or

exceloffthegrid.com

Oh, I thought you meant a native Excel function, you're talking about a creative combination of user design. Yeah, cool!