+ Reply to Thread
Results 1 to 3 of 3

can't seem to use application.filedialog twice

Hybrid View

timmatthews can't seem to use... 12-20-2013, 10:13 AM
nathansav Re: can't seem to use... 12-20-2013, 10:18 AM
timmatthews Re: can't seem to use... 12-20-2013, 10:34 AM
  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    18

    can't seem to use application.filedialog twice

    i have been researching this problem a little bit and can find other trying to do it but no real solutions. i want to use filedialog to open an workbook, then recycle that same filedialog to open a second workbook. the problem is when i then try to manipulate the first workbook the contents seem to be that of the second workbook. i have included the macro enabled workbook if not enough i can sanitize the input files and include them.cost_report_v.1.xlsm
    P.S. i left in commented out some things i tried to make it work based on a suggestion i found elsewhere but no dice.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: can't seem to use application.filedialog twice

    you need another
    Set fdgOpen = Application.FileDialog(msoFileDialogOpen)
    after the 1st MsgBox
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    11-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: can't seem to use application.filedialog twice

    this is making me feel really stupid but i inverted 2 variables, there is no problem.

+ 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: 1
    Last Post: 07-11-2013, 05:01 PM
  2. How to extract file name from user selected file via Application.FileDialog
    By Jpdatabase in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2012, 04:45 AM
  3. Abort Options for Application.Filedialog
    By RoyMakaay1985 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2009, 07:39 AM
  4. Application.FileDialog(msoFileDialogOpen) and error 75
    By H.A. de Wilde in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2006, 08:57 PM
  5. Application.FileDialog(msoFileDialogOpen)
    By H.A. de Wilde in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2006, 04:55 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