• Can’t remove a VBA project

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Can’t remove a VBA project

    Author
    Topic
    WSjverl
    AskWoody Lounger
    June 14, 2013 at 3:12 pm #489668

    I am having a problem deleting a VBA project in Excel 2003 SP3 using VBA 6.5.1054. Each time I try to look at the project’s properties, it ask me for a password which I do not know. When I create a new Excel spreadsheet, this particular VBA project is still there. I’ve tried to reload Excel and also to repair it (help, detect and repair) but still no joy. How do I get rid of this project without knowing its password? It is currently causing errors on startup of Excel and also on closing Excel. The source of this project probably came from an earlier version of Excel which I had tied to my Palm using MobileDB (that is also the name of the VBA project). The errors started when I tried to run an earlier spreadsheet. Now each time I try to create a new spreadsheet I get the same VBA errors. Any ideas?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • Andrew Lockton
      AskWoody_MVP
      June 14, 2013 at 7:34 pm #1397101

      Can you save it in xlsx format? That would remove the modules and may be possible to do if you have loaded the MS tools that lets you open files of that type from Excel 2003.

      If you had access to a machine with Excel 2007 or later it might work better.

      Reply | Quote
      • WSjverl
        AskWoody Lounger
        June 15, 2013 at 6:29 am #1397129

        Thank you for answering Andrew. This would solve my old spreadsheet problem. How do I remove the VBA project from Excel? Every new spreadsheet I create has this project attached to it.

        Reply | Quote
    • RetiredGeek
      AskWoody_MVP
      June 15, 2013 at 9:46 am #1397143

      jevrl,

      Sounds like you have the project in a workbook located in your XLStart directory. In Win7 that would be [noparse]C:Users{your userid}AppDataRoamingMicrosoftExcelXLSTART[/noparse]. You’d need to remove the workbook from that directory or at least remove the project from that workbook. HTH :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

      Reply | Quote
      • WSjverl
        AskWoody Lounger
        June 15, 2013 at 2:48 pm #1397177

        Thanks everyone for the help. I finally figured out my problem. It seems MobileDB created an add-in to Excel which populated a VBA project to each spreadsheet I created. I deleted MobileDB (including all traces of it in the registery), rebooted and voila – problem solved. I re-installed MobileDB but without the Excel add-in and now everything is working fine.

        Reply | Quote
    Viewing 1 reply thread
    Reply To: Can’t remove a VBA project

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.