Closed Thread
Results 1 to 4 of 4

Folder Dialog Box with Combine Files Code

  1. #1
    Registered User
    Join Date
    08-14-2007
    Posts
    27

    Folder Dialog Box with Combine Files Code

    Hello all,

    I have the below code which combines files in a designated folder. I would like to have excel prompt the user to browse to the folder where the files are, rather than have the folder path hard coded. I have tried various ways but cannot get it to work. Can anyone assist? I would like to accomplish this without dramatically altering my exisiting code...since it otherwise works great. Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Folder Dialog Box with Combine Files Code

    I googled it to find this link. Not tried it but.
    http://www.mrexcel.com/forum/showthread.php?t=294728
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  3. #3
    Registered User
    Join Date
    08-14-2007
    Posts
    27

    Re: Folder Dialog Box with Combine Files Code

    Hi John,

    Yes I saw that website as well. In fact, I tried at no avail to integrate that code with mine. Maybe it's a case of not knowing how to plug it in (my VBA skills are beginner at best).

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Folder Dialog Box with Combine Files Code

    This is a duplicate post of this one, so I'm locking this.

    Please do not duplicate threads in future.
    Remember what the dormouse said
    Feed your head

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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