Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Folder Opening (XP)

    One of my Excel students asked me to try and find out how he can:

    Open more than one folder at a time without, obviously, opening them one at a time. He specified he would like for this mutliple-opening to occur when he is assigning paths for .mp3 files, for example - he has all his music in folders by category, I guess.

    Anyway - any help you can give me to share with him will be greatly appreciated.

    Aunt Linda

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Folder Opening (XP)

    In what program does your Excel student want to open multiple folders, and what does he actually want to happen as a result?

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    I'm assuming (he is from Mexico and communicates in English with some difficulty) he wants to go to his My Music folder wherein he has many different folders (for example, Jazz, Latin, Rock, etc) into which he wants to download or copy music files - he wants to have ALL of them open with one command - at least, that's what I think I heard him say.

    ???????? So what do you think?

    PS I was just speaking to friend who is originally from a small town near Durham and who was residing in Derbyshire when she left England to come here with her husband to open a business - she'd give anything to have not made that decision now - but here she is.

    Anyway - thanks for replying so quickly - any help will be appreciated.

    Aunt Linda

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Folder Opening (XP)

    I'm not sure this will quite do what he wants, but if you're in Windows Explorer and click on the folder whose subfolders you want to expand, you should make sure that the NumLock light is lit then press the </big>*</big> key on the numeric keypad.

    John

    PS This can cause problems if you have a huge number of folders that need to be expanded - my attempts come up with a Windows Live signon screen after a fair amount of expansion!
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    Pretty cool but he wants the folders to actually OPEN simultaneously . . . lazy man!

    Thanks anyway

    Aunt Linda

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Folder Opening (XP)

    If his PC has infinite power and infinite disk speed and infinite data bus transfer rate then he will be fine!

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    Ha Ha! I'll tell him! Again, thanks for the info.

    Linda

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Folder Opening (XP)

    The * key on the numeric keypad works for me to expand all subfolders of the selected folder whether Num Lock is on or off.

  9. #9
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Multiple Folder Opening (XP)

    If I select multiple folders in the right hand pane in Explorer, using shift click or control click, and then right click on one of them and choose Open, it seems to do what you want.

    StuartR

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Folder Opening (XP)

    If your student wants to expand *all* subfolders, John's suggestion of using the * key on the numeric keypad is the way to go.
    If he wants to open a number of folders in separate windows, he can select the folders using any of the standard methods (dragging a rectangle around them, or click then Shift+click, or Ctrl+clicking individual folders) in Windows Explorer, then press Enter or select File | Open.

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    You and Hans gave me exactly what I think my student wants - YAY!

    Thank you - again and again

    Linda

  12. #12
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    You and Stuart are right on the money - again.

    My student and I both thank both of you.

    Linda

  13. #13
    Silver Lounger
    Join Date
    Oct 2002
    Posts
    1,993
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    Hi Hans,
    Seems you and Stuart gave good examples, separate Windows.

    Since it is mentioned in this thread, the *, to expand all subfolders, I thought one could also mention as I did in this <post:=607,142>post 607,142</post:>; by using Alt-* you expand all entries under your selection, one level in each branch at a time, each time you use it. Can be useful if one know there are a lot of folders and want to move in steps.

  14. #14
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple Folder Opening (XP)

    Hi There

    Late for the party, but if they are an Excel student, tell 'em to use excel <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I believe this bit of code came from the Lounge somewhere but has been really useful for me to list my cofiguration files for my work and can be used perfectly for listing music and sub-folders on an Excel spreadsheet

    Chuck this bit of code in a module:

    <pre>Sub ListFiles()
    Dim i As Integer
    Dim j As Integer
    Dim strFile As String
    Application.ScreenUpdating = True
    Cells.ClearContents
    With Application.FileSearch
    .NewSearch
    ' Substitute correct path
    .LookIn = "Cocuments and Settings[STUDENT_NAME]My DocumentsMy Music"
    .SearchSubFolders = True
    .FileType = msoFileTypeAllFiles
    .Execute
    For i = 1 To .FoundFiles.Count
    strFile = .FoundFiles(i)
    j = InStrRev(strFile, "")
    Range("A" & i) = Left(strFile, j - 1)
    Range("B" & i) = Mid(strFile, j + 1)
    Columns("A:B").AutoFit
    Next i
    End With
    Application.ScreenUpdating = True
    End Sub
    </pre>

    Jerry

  15. #15
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Folder Opening (XP)

    I'll be sure and give this to him - way beyond me, but I'll be he'll get it! Thanks!

    PS : I totally agree with the Excel use suggestion.

    Aunt Linda

Page 1 of 2 12 LastLast

Posting Permissions

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