Forum Discussion

TheWeav's avatar
TheWeav
Copper Contributor
Jan 17, 2019
Solved

Spreadsheet with VBA coding opens blank

Dell Latitude laptop E5500 Windows 10 Professional Excel Office XP Standard (2007 Conversion) My spreadsheets have been opening fine until I added a "ClearCommand" control. Now when I attempt to o...
excel
  • JKPieterse's avatar
    JKPieterse
    Jan 21, 2019
    That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
TheWeav's avatar
TheWeav
Copper Contributor
Jan 18, 2019

I have discovered this problem has nothing to do with macros or VBA coding. The laptop is my wife's. I have made a few spreadsheets for her. The last one was a year ago and it opens ok. Any spreadsheets made now open with a gray blank screen, with or without controls using macro or VBA. A screenshot is attached. I apologize for the confusion.

 

JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 20, 2019
If you use FIle, Open to open the file in question, does it open then?
  • TheWeav's avatar
    TheWeav
    Copper Contributor
    Jan 21, 2019

    Yes.

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jan 21, 2019
      That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
      • TheWeav's avatar
        TheWeav
        Copper Contributor
        Jan 21, 2019

        I had already adjusted the file associations in Default Apps, and the File Type in the spreadsheet. It worked perfectly for a couple of reboots, then quit. Thanks to your suggestion, I did the repair. It didn't work at first, so I went back into File Associations and found that the repair had duplicated some of the associations. I clicked on the duplicate files, and when I did, they turned into a single file. Now my spreadsheets are working, with and without macros. I did have to go into my spreadsheets and change a couple of File Types. Thanks again for helping.