+ Reply to Thread
Results 1 to 2 of 2

GetOpenFilename Not Working

  1. #1
    Registered User
    Join Date
    10-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    GetOpenFilename Not Working

    I have very simple code. I just want to open a file. The open file dialog opens, I select my file, but it doesn't actually open. Any ideas?

    Sub OpenFileCopySheet()
    Dim filename

    filename = Application.GetOpenFilename("Excel Files (*.xlsx),*.xlsx")

    End Sub

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,186

    Re: GetOpenFilename Not Working

    Hi, Jmk326,

    please wrap your procedure with code-tags when presenting it here.

    GetOpenFilename will only deliver a string with the path and name of the file, no opening is integrated in this command. The opening could be done like
    Please Login or Register  to view this content.
    You could consider using an integrated dialog which would open the file instantly.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. GetOpenFilename
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2012, 03:25 PM
  2. GetOpenFilename, .xls And .txt
    By RobynC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2007, 07:56 AM
  3. Using GetOpenFilename
    By treva26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2007, 11:17 PM
  4. working on a selected file via GetOpenFilename
    By periro16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 08:52 AM
  5. [SOLVED] GetOpenFilename
    By Roman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2005, 07:06 PM

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