Consulting

Results 1 to 4 of 4

Thread: Solved: Pulling file name from dialog

  1. #1

    Solved: Pulling file name from dialog

    I have a browse window open and what I want to do is pull the selected file name (or file path including file name) and dispay it in a text box. Pretty much simulating how it works already. I'm just tryin to create my own operation. Does anyone know how I would do that?

    Thank you

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Excel can do this, so as long as you have Excel installed we can borrow the function to use in PowerPoint.

    [vba]

    Dim AppExcel As Object
    Dim Path As String

    Set AppExcel = CreateObject("Excel.Application")
    Path = AppExcel.GetOpenFilename("PowerPoint Files (*.ppt), *.ppt")
    MsgBox Path
    AppExcel.Quit

    Set AppExcel = Nothing
    [/vba]

  3. #3
    Oh ok, thanks alot man.

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    You're Welcome

    Take Care

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •