Hi All,
a COM Add In, that work very well with Excel 2003 and Excel 2002, don't work
in Excel 2007 Beta 2.
It is written in VB6. A function is called by a VBA macro of an example
worksheet file.

If the example worksheet file is opened in 'Compatibility Mode', in VB6
Debug mode I realized that, in the line below, occurs an error (wich don't
occurs with Excel 2002/3):

Wb.Sheets("Calc_Sheet").Cells(7, 5).Font.Bold = True

where Wb is defined as an Excel.Workbook.
Error raised is:
Err.Number -- 1004
Err.Description -- "Unable to set the Bold property of the Font Class"

After converting the example worksheet file into an Excel 2007 Macro Enabled
(.xlmb) line above works but some other don't BUT I can't isolate error
because the Excel notification

"Microsoft Office Excel is waiting for another application to complete an
OLE action"

raise an erron in a randon line.

O.S. is Windows XP Pro English fully patched. VB is 6 English with SP5.
Many Thanks.
Regards.


================================================== =======
BELLANTONE MAURIZIO - Teacher, IT Consultant, Programmer
SPINETTA MARENGO (AL) - ITALY
---------------------------------------------------------
E-mail: bellantoneCHIOCCIOLAlibero.it
================================================== =======