Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't remove a VBA project

    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?

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,515
    Thanks
    3
    Thanked 143 Times in 136 Posts
    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.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  4. #3
    New Lounger
    Join Date
    Jun 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  5. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,192
    Thanks
    201
    Thanked 784 Times in 718 Posts
    jevrl,

    Sounds like you have the project in a workbook located in your XLStart directory. In Win7 that would be C:\Users\{your userid}\AppData\Roaming\Microsoft\Excel\XLSTART. You'd need to remove the workbook from that directory or at least remove the project from that workbook. HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  6. #5
    New Lounger
    Join Date
    Jun 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •