Issues selecting old workbook with "Import" macro

  • When I click the import button to run the macro, it opens up file explorer to let me select a workbook to import from. However, when testing, I can't see any excel files in any of my folders even though I can see that other Excel files are there in another file explorer window.


    The workbook I'm using is a collection checklist of sorts for a card game. Each set has a sheet where you can input the number of a card you own and I have a macro to import those numbers from an old version of the Excel file to the updated version. The file is shared online with some friends that play, so as new sets come out and the main file gets updated, it makes it easier for everyone to keep their lists updated. I'm not very good at coding, as it is not my profession, just something I happened to write for my hobby this one time.


    Any help would be appreciated. Thanks in advance!

  • It's a little hard to fix code that we can't see... ;)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • That is true. Here is the code:


  • Your code is filtering to only show the older .xls format - is that the format of your workbooks, or are they the newer xlsx/xlsm/xlsb format?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why