Try the given solution to fix solution to fix the error VBA error1004

1. Right click on the start menu
2. Then select the Explore option
3. Then open the following directory – C:\Program Files\MSOffice\Office\XLSTART
4. Here you need to delete “GWXL97.XLA” file
5. And open the excel after closing the explorer

repairmsexcel.com