Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.office.developer.com.add_ins,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Beta 2: COM AddIn don't work
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 ================================================== ======= |
#2
Posted to microsoft.public.office.developer.com.add_ins,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Beta 2: COM AddIn don't work
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" <bellantoneCHIOCCIOLAlibero.it wrote in message ... 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 ================================================== ======= |
#3
Posted to microsoft.public.office.developer.com.add_ins,microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Beta 2: COM AddIn don't work
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 --------------------------------------------------------- E-mail: bellantoneCHIOCCIOLAlibero.it ================================================== ======= ha scritto nel messaggio ... 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 @. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Excel 2007 Beta 2 Bug Posts | Excel Discussion (Misc queries) | |||
Excel 2007 Beta | Excel Programming | |||
Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions |