Microsoft excel VBA is returning this error - "Automation Err Exception occurred." which goes off once we open Developer- Visual basic code window

The issue happens on press of a button called Export. No changes in code required after opening Developer but it works fine once we close it and try again.