Excel 2007 Converter RRS feed

  • Question

  • I have a visual basic open file command that works while running from Excel 2007 but when a user tries to run the macro from a machine running Excel 2003, the command does not work.

    The 2003 (utilitilizing 2007 converter) will not recognize the writerespassword:="xxx" on the open file command and still asks for the user to input the password. 

    Any suggestions will be extremely helpful.

    Workbooks.Open Filename:="Builder Information 12.xlsm", WriteResPassword:="XXXXXXX", ignorereadonlyrecommended:=True, UpdateLinks:=0



    Wednesday, January 28, 2009 6:21 PM