ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   all filenames on A:\ into Excel? (https://www.excelbanter.com/excel-programming/354709-re-all-filenames-%5C-into-excel.html)

Norbert Jaeger

all filenames on A:\ into Excel?
 
I figured it out by tweaking a macro which I had to download
mp3-filenames

Regards,
Norbert


On Wed, 01 Mar 2006 11:22:15 +0200, Norbert Jaeger
wrote:

I have a lot of 3.5" disks which I would like to sort out.
I need a macro which will fetch the filenames (without extension) from
the floppy and copies them into column A (just underneath each other)
It would be great, if the macro could ask me for an input (disk
number) so I can put in the number, which then should be stored in
column B.

How is something like that to be done?
I checked the history of this newsgroup but unfortunately I couldn"t
find something suitable.

Thanks for any help.

Norbert




All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com