I'm having the toughest time figuring out how to merge cells , allign cells (i.e center the text in a merged cell) and create a new worksheet to an existing spreadsheet in excel using Ole automation. Does anyone have any suggestions ?
Also Does anyone have an example of how the excel header file (Excel.h in your files section ) is used. I dont quite understand when and how to use the constants.
Is there any documentation/ book that makes more than a passing reference to this OLE stuff--- for a beginner to OLE automation ?


Thank you in advance
Brian