Export and Import Methods no longer work with Windows 7 and/or Excel 2010 RRS feed

  • Question

  • i have code in an excel spreadsheet that stopped working since my laptop was upgraded to windows 7 and excel 2010

    this is the code...

    wbsource.VBProject.VBComponents("mod_Hyperlinks_Process").Export ("C:\modules\mod_hyperlinks_process.bas")

    wbdestination.VBProject.VBComponents.Import ("C:\modules\mod_hyperlinks_process.bas")

    i am not getting any errors messages when it executes these two lines

    i can manually export and import the modules

    Wednesday, October 15, 2014 5:13 PM


  • Have you trusted VBA access to your projects?

    In Excel, choose

    File   - Options -  Trust Center - Trust Center Settings....   Macro Settings    and then check "Trust access to the VBA project object model"

    Wednesday, October 15, 2014 7:50 PM