+ Reply to Thread
Results 1 to 2 of 2

VbA code to open a dialog box from where we can select the file

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    883

    VbA code to open a dialog box from where we can select the file

    Hi Guys

    I want to write down vba code so that when I click on Browse button then it opens up a dialong box so that i can select the name of the file and then that selected file should appear in the textbox1 near to Browse button.

    Any help would be much appreciated.

    Thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: VbA code to open a dialog box from where we can select the file

    Take a look at Application.GetOpenFilename.
    If posting code please use code tags, see here.

+ 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. Replies: 12
    Last Post: 07-30-2014, 04:34 PM
  2. Code to select, and then open CSV file into an Excel sheet
    By Rschwar2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2012, 05:55 PM
  3. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM
  4. select File Open Dialog Box
    By izet99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2008, 03:39 AM
  5. Code for bring up the file->open dialog box
    By Ben in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2006, 11:25 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