Excel 2007 Beta 2: COM AddIn don't work

[Maurizio BELLANTONE]

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

 

[Guest]

Hi Maurizio,

I just gave this a try in the most recent builds and this seems to be
working the same as in Excel 2003. But, if you could send me the code that
you've got via email, I'd be happy to give it a try and make sure it works.

Cheers,
Dan
Excel Team

Note: We've only got a couple weeks to get bugs filed and fixed, so if I've
requested additional info via email, it'd be great if you can get that to us
ASAP. Please include any necessary sample files, as well as detailed repro
steps so that we can try to reproduce the problem on our side. Also - if
you're emailing me directly (definitely the most efficient at this point)
you'll want to fixup my email address to remove everything after danbatt and
before the @.

 

[Maurizio BELLANTONE]

Thank you.
At the time I sent those message to mewsgroups, I sent sample code to Excel
Beta Team [Gainer, Parris, Simpson], and then told me that problem go away
with latest build. They sent me snapshot of my apps running witout problems.
Regards,

Maurizio Bellantone

=========================================================
BELLANTONE MAURIZIO - Teacher, IT Consultant, Programmer
SPINETTA MARENGO (AL) - ITALY