Microsoft KB Archive/232332

= XL2000: Bidi Excel5 VBA Font Properties Are Not Mapped to New Ones =

Article ID: 232332

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q232332



NOTE: This article discusses complex scripts functionality. Complex scripts functionality is available when you use the Office Language Settings tool to enable a language, such as Arabic or Hebrew, that requires this functionality. For more information about multilingual features, click Microsoft your Office product Help on the Help menu, type multilingual features in the Office Assistant or the Answer Wizard, and then click Search to view the topics that are returned.



SYMPTOMS
When you type Microsoft Visual Basic for Applications code in a module sheet and attempt to run the code, you receive the following error message:

Run-time error '438':

Object doesn't support this property or method



CAUSE
Your code contains one of the following bidirectional (BiDi) Visual Basic for Applications dual font properties or methods that are no longer supported after Microsoft Excel version 5.0:


 * xlDefault
 * xlArabic
 * xlEnglish
 * xlDialogOptionsArabic
 * BidiName
 * BidiFontStyle
 * BidiSize
 * StandardBidiFont
 * StandardBidiFontSize
 * xlLTR (when used with Object.DisplayRightToLeft where Object is either ActiveSheet or Activewindow)
 * xlRTL (when used with Object.DisplayRightToLeft where Object is either ActiveSheet or Activewindow)
 * xlContext (when used with Object.HorizontalAlignment where Object is referencing a Cell range)



WORKAROUND
Do not create new workbooks that reference bidirectional dual font properties that are no longer supported.

For existing Excel 5.0 workbooks with bidirectional dual font references, convert the file into a Microsoft Excel 2000 workbook by opening it in Excel 2000. During conversion, Excel maps bidirectional dual font properties to font properties that can be saved.



MORE INFORMATION
The following table describes how Microsoft Excel 2000 converts the legacy bidirectional dual font properties:   From                    To   xlDefault               xlContext xlArabic               xlBidi xlEnglish              xlLatin xlDialogOptionsArabic  xlDialogOptionsME BidiName               Name BidiFontStyle          FontStyle BidiSize               Size StandardBidiFont       StandardFont StandardBidiFontSize   StandardFontSize NOTES:

This conversion occurs only while migrating from Excel 95 and Excel 5.x to Excel 97 or Excel 2000. Excel performs the conversion to preserve functionality and to enable these projects to run without errors. Make sure not to save the projects back in an Excel 95 and 5.x format and do not attempt to run them.

You must modify the following conversions manually:
 * Change Object.DisplayRightToLeft = xlLTR to Object.DisplayRightToLeft = FALSE (where Object is either ActiveSheet or Activewindow).
 * Change Object.DisplayRightToLeft = xlRTL to Object.DisplayRightToLeft = TRUE (where Object is either ActiveSheet or Activewindow).
 * Change Object.HorizontalAlignment = xlContext to Object.HorizontalAlignment = xlGeneral, if Object was referencing a Cell range, otherwise change xlContext to XlLTR or xlRTL.

Additional query words: vba font properties bidi bi-di bi-directional right-to-left Run-time error 438 Object doesn t support this property or method

Keywords: kbbidi kberrmsg kbprb KB232332

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.