Forum Discussion
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...
- That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
Yes.
That probably means your file associations somehow went haywire. Best is to open Office setup and let it do a Quick repair.
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.
- You're welcome!