Apparently 'xlCSV' just stands for '6', which Excel interprets as saving as CSV format. So if I do:
SaveAs(eSheet1,'C:\myfile.csv','6') % Saves as CSV
this works and solves my issue. I have no idea why 'xlCSV' does not work, but I'll leave this post in case others have similar issues in the future.