none
Excel 2016 VBA not working on Excel 2010 RRS feed

  • Question

  • Hi!

    One of my users has created Excel workbook that has VBA code inside. 

    However when users on Excel 2010 try to run it they get message "Run-time error '1004': Class not registered"

    When I try to Debug it points to this command and I'm unable to Step over:

    We plan to upgrade this Office 2010 to 2016 soon. However I'd like to know what is the root cause of this error.

    Is it possible that .RefreshAll does not exist in Excel 2010 VBA ?

    Thanks for any help!

    Regards!

    Thursday, November 9, 2017 8:05 AM

All replies

  • Hi boris.bahes,

    I'm wondering why you're asking about Excel 2010 VBA. Don't you have a plan to upgrade from Office 2010 to 2016?

    Putting that aside, ActuveWorkbook.RefreshAll can be used in Excel 2010.    

    I've just checked it and it worked with no errors.
        (this Office 2010 is Japanese version)
        
    I hope you will provide more detail of the issue.

    Regards,

    Ashidacchi


    • Edited by Ashidacchi Thursday, November 9, 2017 9:05 AM
    Thursday, November 9, 2017 9:03 AM
  • Our company does not want to invest in new licenses of Office for new employees so they get old licenses like 2010, 2013...

    I could send you private e-mail with this .XLSM ?

    • Edited by boris.bahes Thursday, November 9, 2017 9:44 AM
    Thursday, November 9, 2017 9:42 AM
  • Hi boris.bahes,

    Thank you for explanation about Office licenses and your situation.
    I hope you will provide your e-mail address before I do it.

    Regards,

    Ashidacchi

    Thursday, November 9, 2017 10:40 AM
  • you can contact me on my business e-mail: boris . bahes @ multinorm . hr

    Thanks!

    Thursday, November 9, 2017 11:58 AM
  • Thanks!

    I've sent an email.
    If you can receive it, please mask or delete you address from your post.

    Regards,

    Ashidacchi

    Thursday, November 9, 2017 12:18 PM
  • Hi Boris Bahes,

    (1) Please mask or delete your e-mail address for your privacy.
    (2) I received and unzipped your file, and found 3 files in it.
          (a) Copy of festo_skladiste.xlsm
          (b) festo_skladiste.xlsmt
          (c) Kopie von festo_skladiste_1.xlsm
        Please give me a brief explanation about each file. 

    Regards,

    Ashidacchi

    Friday, November 10, 2017 2:17 AM