+ Reply to Thread
Results 1 to 2 of 2

Bring up Browse Dialog Box for folder path

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    28

    Bring up Browse Dialog Box for folder path

    Hello,

    I am attempting to bring up a dialogue box to get the folder path but I cannot seem to get the code to work properly. I get the error, "Run-time error '5': Invalid procedure call or argument.

    I want to use this folder path for some operation later on.

    How to properly save the folder path to a variable "myFolder"?


    This is a snippet of my code:


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Bring up Browse Dialog Box for folder path

    Uncomment your .Show line. Otherwise, it should run fine providing that you set the fso object reference.

    Dim sItem as String

+ 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. Browse Folder Dialog - show msgbox if nothing selected
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2014, 08:24 PM
  2. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  3. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  4. Different 'Browse for Folder' dialog?
    By Jon.R in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 02:30 PM
  5. Excel 2010 64-bit Browse for folder Dialog box
    By c.vaibhav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2010, 02:27 PM
  6. [SOLVED] Browse button on form for folder path
    By Greshter in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 06:25 PM
  7. Hard Code Folder Path for Browse Box
    By adamkozyra in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 10:41 AM

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