For sure always love to circle back and post the solution, chances are I’ll be searching for my own solution in a year or two 
I think @JeffLeBert broke this back in his early days.
2 Likes
I owe you another a drink at Insights sir.
1 Like
Resolution was simple > open control panel > select Devices / printers > right click on a different printer > Set as default > change back to original default printer > test “Copy to Excel” should work.