+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
Scripts Thread, need a script to take a DIR list to XLSX in Coding and Web Development; @ Mr_J - you're welcome, I love little challenges like this they keep me sane! Also, did anyone spot my ...
  1. #16

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,562
    Thank Post
    1,469
    Thanked 1,221 Times in 830 Posts
    Rep Power
    752
    @Mr_J - you're welcome, I love little challenges like this they keep me sane!

    Also, did anyone spot my deliberate mistake?

    Quote Originally Posted by LosOjos View Post
    Code:
    cscript dirtoxlsx.vbs /Root:\\server\Folder\Example /SaveAs:C:\example\dir.xlsx > C:\example\log.txt
    That should have been a double right operator (>>) to append to log.txt rather than overwrite

    Code:
    cscript dirtoxlsx.vbs /Root:\\server\Folder\Example /SaveAs:C:\example\dir.xlsx >> C:\example\log.txt

  2. #17


    Join Date
    May 2009
    Posts
    3,275
    Thank Post
    290
    Thanked 883 Times in 661 Posts
    Rep Power
    339
    Just for interest (for small values of interest), in powershell a csv of directories with various attributes listed for each directory could be produced by :

    Get-ChildItem "\\<server>\<share>" * | where {$_.PsIsContainer} | Export-Csv c:\tmp\dirlist.csv -notype

    And if you want to recursively list the folders add the -r switch.

    Get-ChildItem "\\<server>\<share>" * -r | where {$_.PsIsContainer} | Export-Csv c:\tmp\dirlist.csv -notype

    Yea - I hate powershell too.
    Last edited by pcstru; 12th July 2013 at 02:02 PM.

  3. 2 Thanks to pcstru:

    LosOjos (12th July 2013), Mr_J (12th July 2013)

  4. #18

    Join Date
    Jul 2011
    Location
    West Yorkshire
    Posts
    17
    Thank Post
    16
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    of course i spotted it @LosOjos! *CougH* :s

    i just didn't want to make you feel bad!

    thanks again!

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. terminal script to create home dirs in OS X
    By HodgeHi in forum Coding
    Replies: 6
    Last Post: 3rd July 2009, 10:13 AM
  2. need a script to copy a folder with shortcuts
    By jamin100 in forum Scripts
    Replies: 1
    Last Post: 4th September 2008, 07:38 PM
  3. Replies: 21
    Last Post: 29th December 2007, 10:53 PM
  4. need a script to delete shortcuts
    By philtomo-25 in forum Scripts
    Replies: 2
    Last Post: 1st November 2007, 03:50 PM
  5. Need a script to run programs
    By timbo343 in forum Scripts
    Replies: 9
    Last Post: 26th September 2007, 12:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •