+ Reply to Thread
Results 1 to 2 of 2

Windows Explore tree

  1. 12-15-2006, 03:38 PM #1
    jimbo_jones
    jimbo_jones is offline
    Registered User
    Join Date
    09-14-2005
    Posts
    44

    Windows Explore tree

    Hello All,

    Is it possible to have a file tree for selecting places to save workbooks?

    So just like you would use windows explorer to click on the folders, can this be done in excel vba? So when I want to save a file in MyDocuments I have this tree appear on my form?

    I found something called TreeView, can this work in excel?

    Thanks!
    Last edited by jimbo_jones; 12-15-2006 at 04:19 PM.
    Reply With QuoteRegister To Reply
  2. 12-15-2006, 05:07 PM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Have you looked at using

    Application.FileDialog (msoFileDialogSaveAs)


    Or for early versions of Excel
    fileSaveName = Application.GetSaveAsFilename( _
    fileFilter:="Excel_Files (*.xls), *.xls")

    or

    fileSaveName = Application.GetSaveAsFilename( _
    fileFilter:="Text Files (*.txt), *.txt")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1