Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Thread: Listing of Files and Worksheets

  1. #1
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Listing of Files and Worksheets

    Hi All,

    Self explanatory Title

    I hope it's useful to atleast some of you !

    Note: Change the path before clicking the button.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,784

  3. #3
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    5,196

    Re: Listing of Files and Worksheets

    Nice work Kris... thats a keeper.

    Check out our new reputation system. Click on the "star" under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Listing of Files and Worksheets

    Hi,

    Thanks Dave, Ger.

  5. #5
    Join Date
    18th April 2007
    Location
    Boise, Idaho
    Posts
    157

    Re: Listing of Files and Worksheets

    Wow it works good. Even shows the names of the sheets not visible also.

    Simply amazing Kris
    Thanks,
    David
    Bad news. These are the good old days.

  6. #6
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Listing of Files and Worksheets

    Hi,

    Thanks David

  7. #7
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Listing of Files and Worksheets

    A modified version.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  8. #8
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,784

    Re: Listing of Files and Worksheets

    Kris, why not use;

    VB:
    With Application.FileDialog(msoFileDialogFolderPicker) 
        .Show 
        FilePath = .SelectedItems(1) 
    End With 
    
    
    to get the folder path?


    Anyway, would you mind if I used this in our next Newsletter? I will, of course, give you full credit and a link to your blog, so get some AdSense set-up

  9. #9
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Listing of Files and Worksheets

    Hi Dave,

    That won't work in 2000 version.

    Anyway, would you mind if I used this in our next Newsletter? I will, of course, give you full credit and a link to your blog, so get some AdSense set-up
    Go ahead.

  10. #10
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    5,196

    Re: Listing of Files and Worksheets

    Hi Kris, I know its slightly off topic, and youre probably aware of this, but for anyone else interested, Jim Rech wrote some fairly slick code to allow a user to Select a Folder in Excel 2000. I've used it myself under permission from Jim in my own Apps.

    Can be downloaded here -

    http://www.oaltd.co.uk/MVP/Default.htm

    (about half way down the page)

    This bit of wizardry demonstrates how to call the Windows API to show the standard “browse for folder” dialog. The technique demonstrates how to use callback functions with Excel 97 and Excel 2000 in order to pre-select the initial folder. See the “Discussion” sheet in the workbook for a more detailed explanation. Version 2.0 adds support for the Windows 2000 “new style” browse dialog as well as for centring the dialog on screen.
    Worth a look, if youre into that kind of thing ;-)

    Ger

    Check out our new reputation system. Click on the "star" under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Listing And Hyperlinking Worksheets
    By Belinda Li in forum Excel General
    Replies: 7
    Last Post: May 30th, 2007, 15:25
  2. Directory Listing: skips .zip files
    By cscribner in forum Excel General
    Replies: 2
    Last Post: June 13th, 2006, 00:28
  3. Getting listing of files in directory
    By squeegedog in forum Excel General
    Replies: 2
    Last Post: October 20th, 2005, 12:29
  4. VBA Listing names & dates of files in a directory
    By digita in forum Excel General
    Replies: 2
    Last Post: March 8th, 2005, 09:27
  5. listing info from multiple worksheets
    By Gillian in forum Excel General
    Replies: 1
    Last Post: April 19th, 2003, 21:26

Bookmarks

Posting Permissions

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