TypeError: This COM object can not automate the makepy process - please run makepy manually for this object

Solution 1:

Encountered the same issue and resolve it by closing all running Excel applications.