+ Reply to Thread
Results 1 to 2 of 2

GetOpenFilename Not Working

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2007

    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
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)

    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.

    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


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