locked
converting 2003 vba to 2010 vba RRS feed

  • Question

  • I am trying to update my Personal vba code from 2003 to 2010.

    Is there a list somewhere that matches the old functions with the new ones?.  ie  I am currently not able to compile the code as it is rejecting "Time".  Before it rejected "Left" but I found that one.

    Any help would be greatly appreciated.

    Ta,

    Martin

    Monday, August 23, 2010 5:36 AM

Answers

  • Martin Wheeler wrote on 8/23/2010 7:36 a.m. CEST:
    ie  I am currently not able to compile the code as it is rejecting "Time".  Before it rejected "Left" but I found that one.

    In the VBA editor go to Tools -> References. Check for missing references and remove them if necessary.

    Peter


    • Marked as answer by Ji.Zhou Friday, August 27, 2010 4:14 AM
    Monday, August 23, 2010 6:15 AM

All replies

  • Martin Wheeler wrote on 8/23/2010 7:36 a.m. CEST:
    ie  I am currently not able to compile the code as it is rejecting "Time".  Before it rejected "Left" but I found that one.

    In the VBA editor go to Tools -> References. Check for missing references and remove them if necessary.

    Peter


    • Marked as answer by Ji.Zhou Friday, August 27, 2010 4:14 AM
    Monday, August 23, 2010 6:15 AM
  • Hi Peter,

    Thanks I will give it a go.

    Ta,

    Martin

    Monday, August 23, 2010 6:30 AM
  • Hey it worked!!  Thanks a lot. 

    Ta,

    Martin

    Monday, August 23, 2010 8:42 AM