+ Reply to Thread
Results 1 to 4 of 4

Exporting Folder names to a Text File

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,687

    Exporting Folder names to a Text File

    For years I've been using the Macros below to create a searchable list of my Outlook folders because I have over 50 Main folders and each of them has 2 or three levels of subfolders. It's a major chore to find the buried subfolder I need, and (as far as I can see) Outlook doesn't easily tell you the path to a folder I'm looking for.

    The macro has been trouble-free since I started using it, and just recently it's started to fail at the line shown in red. We're still using Outlook 2010. The only recent changes are that we've moved away from using the PST files that we stored locally. Instead they are now in a system-generated folder titled "PST_Migration". Not sure how that would have hosed the macro, but then again I'm no expert at Outlook coding. Any help I can get would be greatly appreciated. Thanks in advance.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Exporting Folder names to a Text File

    one reason for that line to fail is that there is nothing selected (no selection)

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,687

    Re: Exporting Folder names to a Text File

    I'm so glad you pointed that out. I don't know how I got that whole "Check the range size" subsection in there. I use that code in a few macros to help my users use their tools more effectively, but it doesn't apply to the macro in question. I must have pasted it in accidentally. Removing that subsection clears up my problem. Now I'm wondering where that subsection was supposed to go!

    Thanks for the help!

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Exporting Folder names to a Text File

    you are welcome. please mark it as solved (if your question was answered)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Requirement with folder names and file names
    By sateesh konduru in forum Excel General
    Replies: 3
    Last Post: 04-21-2015, 10:09 AM
  2. Exporting as a PDF then openeing folder location rather than actual file...
    By scoutexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2014, 07:44 PM
  3. Excel Names in column to text files names to folder
    By excelaron in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2013, 07:22 PM
  4. [SOLVED] Student names in column save as text file to folder on c: Drive
    By excelaron in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2012, 01:35 PM
  5. read in folder names and file names
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2011, 12:45 PM
  6. Exporting folder contents to excel or text format
    By Sr. Bio in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 02:55 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1