1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

CD catalog - simple but not easy

Discussion in 'Other PC Software' started by merlin, 2003/04/21.

Thread Status:
Not open for further replies.
  1. 2003/04/21
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Hi all,
    Can anyone point me to/write an app that will do this :

    - I put a CD in the drive
    - on the CD are a number of folder names
    - the app can write the folder names to a .csv file for import
    to an Excel worksheet, or better still, create an Excel worksheet.

    regards
     
  2. 2003/04/22
    TonyT

    TonyT SuperGeek Staff

    Joined:
    2002/01/18
    Messages:
    9,072
    Likes Received:
    400
    You could probably do it by modifying this .bat file:

    Directory listing in Explorer
    Goto notepad and enter:

    dir %1 /-p /o:gn /B > "%temp%\Dir Listing "
    start /w notepad "%temp%\Dir Listing "
    del "%temp%\Dir Listing"


    Save this file as Dirlist.bat . Now Open Windows Explorer, choose View, then Options, now click on the File Types tab. Select File Folder, then click on Edit and New. Fill in the New Action dialog Box as follows. Action: Get File Listing, Application used to perform action: c:\ (directory where you saved Dirlist.bat file).

    Now when in explorer right click on any FOLDER or DRIVE and the longfilenames will be listed in a new Notepad window that you can save or print.

    You can manually add the commas and save-as a .csv file.
     

  3. to hide this advert.

  4. 2003/04/23
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Thanks Tony,
    I will give it a try and post back.
    Regards
     
  5. 2003/04/23
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Tony,
    A couple of tweaks and it works lovely.
    Thanks and best regards
     
  6. 2003/04/24
    TonyT

    TonyT SuperGeek Staff

    Joined:
    2002/01/18
    Messages:
    9,072
    Likes Received:
    400
    very giood!
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.