none
Migration from Excel 2003 VBA Macros to Excel 2010 VBA Macros

    Question

  • Hello

    I need small help in migration of my macros to Excel 2010

    When i validated my migrated excel sheet to 2010 with OICC tool , I still found some deprecated and removed , Changed items. I do not have idea on this what this tool suggest to change. Please find the attached report i got when i verified with tool.

    I did not understand whether i need to change the code as per excel compitable or not. If not the existing code will work for future excel versions.

    please find the report i got when i generated with OICC tool:

    SUMMARY:
    ========

    Date scanned:   Tuesday, July 09, 2013
    Total lines scanned:  39478
    Total items found:    1638
    Deprecated items:     916
    Removed items:     580
    Changed items:         138
    Redesigned items:     0
    Declare statements:   1
    References Found:      3


    DETAILS:
    ========

    MODULE:  frmPackageIncludes
    FUNCTION: userform_activate
    LINE:  212
    TYPE:  REMOVED
    ITEM:  [mso]FileDialogFilters.Clear

    CODE:  gshtcombo.range("h1").end(xldown).clear

    MODULE:  frmPackageIncludes
    FUNCTION: userform_activate
    LINE:  223
    TYPE:  DEPRECATION
    ITEM:  [xls]SmartTag.Range

    CODE:  for introwx = gkintheaderstartrow + 2 to gshtcpv.range("a1").end(xldown).row

    MODULE:  frmPackageIncludes
    FUNCTION: userform_activate
    LINE:  239
    TYPE:  DEPRECATION
    ITEM:  [xls]SmartTag.Range

    CODE:  gshtcombo.range(gshtcombo.range("h1:i1"), gshtcombo.range("h1:i1").end(xldown)).sort key1:=gshtcombo.range("h1"), order1:=xlascending, header:=xlno, ordercustom:=xlascending, matchcase:=false, orientation:=xltoptobottom

    MODULE:  frmPackageIncludes
    FUNCTION: userform_activate
    LINE:  248
    TYPE:  DEPRECATION
    ITEM:  [xls]SmartTag.Range

    CODE:  cbofeature.rowsource = gkstrcombo & "!h1:" & gshtcombo.range("h1").end(xldown).address

    MODULE:  mdlHideShow
    FUNCTION: mnufeaturewidth
    LINE:  77
    TYPE:  REMOVED
    ITEM:  [mso]OfficeDataSourceObject.Columns

    CODE:  with gshtcpv.columns(gkintfeaturecolumn)

    MODULE:  mdlHideShow
    FUNCTION: mnufeaturewidth
    LINE:  96
    TYPE:  CHANGE
    ITEM:  [xls]Range.AutoFit

    CODE:  .autofit

    MODULE:  mdlHideShow
    FUNCTION: mnufeaturewidthmenu
    LINE:  154
    TYPE:  REMOVED
    ITEM:  [mso]OfficeDataSourceObject.Columns

    CODE:  with gshtcpv.columns(gkintfeaturecolumn)

    MODULE:  mdlHideShow
    FUNCTION: mnufeaturewidthmenu
    LINE:  173
    TYPE:  CHANGE
    ITEM:  [xls]Range.AutoFit

    CODE:  .autofit

    MODULE:  mdlHideShow
    FUNCTION: mnushowdependenciesviewlinks
    LINE:  231
    TYPE:  CHANGE
    ITEM:  [xls]Range.ShowPrecedents

    CODE:  selection.showprecedents

    MODULE:  mdlHideShow
    FUNCTION: mnushowconsensusview
    LINE:  336
    TYPE:  DEPRECATION
    ITEM:  [mso]ChartFont.ColorIndex

    CODE:  if cells(1, 1).interior.colorindex = gkintcolorwhite then

    MODULE:  mdlHideShow
    FUNCTION: mnushowconsensusview
    LINE:  344
    TYPE:  DEPRECATION
    ITEM:  [mso]ChartFont.ColorIndex

    CODE:  cells(1, 1).interior.colorindex = gkintcolorconsensushide

    MODULE:  mdlHideShow
    FUNCTION: mnushowconsensusview
    LINE:  363
    TYPE:  DEPRECATION
    ITEM:  [mso]ChartFont.ColorIndex

    CODE:  if cells(introwx, gkintrelationcolumn).interior.colorindex = gkintcolorgrouptotal then

    Please help me.

    Thanks,

    ganesh

    Tuesday, July 09, 2013 5:38 PM

All replies

  • I have never used OICC tool.

    Why not just copy and paste the code then see if it works?

    If no, you can modify it. You can check if any of those objects has been changed or not through MSDN documents.

    Sunday, July 14, 2013 5:40 PM
  • Hello,

    Thanks for your participation in this forum. But I'm afraid this is not the appropriate forum to discuss OICC related issues because this third-party tool is not supported here.

    This thread will be moved to Off-topic. Your understanding will be appreciated.

    Regards,


    Damon Zheng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, July 15, 2013 9:34 AM