I am also running into an “Error: Reason of 1004”. Saw your solution below, going to answer to that later. Just to leave this here: I though we left those stupid error messages without any reasonable hint on what is going on in the last century. Seems I was very wrong.