I did read the error message. I did not understand why 'constant' was not defined. In perl I did not have to run anything like 'makepy' to get constants to work. And no, I don't want to go back to perl. Python appears to integrate with packages more readily than perl does.
I was unaware of 'makepy' until you mentioned it. Spent 3 hours searching the web and google groups under python excel column | 'centering columns' to find a solution. Never saw anything mentioned about 'makepy'. Thanks. I will do some searches on 'makepy'. Lance John Machin wrote: >> from win32com.client import constants >> sh2.Columns(lastcol).HorizontalAlignment = constant.xlCenter >> NameError: name 'constant' is not defined > > 1. So why not try reading the error message and fixing the problem > instead of thrashing about madly? > > 2. You have run makepy on your Excel library, haven't you? > -- http://mail.python.org/mailman/listinfo/python-list
