Using code to replace code modules

P

PO

Excel 2003, SP2

Hi,

I have distributed a custom template among the coworkers in my company. The
template creates a custom menu. There is however a bug in the menu creation
code and I need to replace it. I have sent out new templates but I still
need to fix the workbooks created by it.

The plan is to have them email me the workbooks and replace the faulty
module "Menus" with a new one (also called "Menus"). I will get help
replacing the modules but the person who will help isn't familiar with the
VBE and I don't want him to have replace the module manually.

Therefore, is there a way to use code (in a separate workbook) to:

1. Unprotect the project (password is RevCalc)
2. Remove the faulty module (Menus)
3. Import the new module (at c:\data\Menus.bas)

Regards
PO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Prompt For Replace in Selection And More... 0
Adding custom menus to existing excel application 0
Word macro that can call cells out of Excel for a find and replace 0
Breaking User Form Code into modules question 9
VBA Macro to create 2003 style menus in 2007 and above 1
Error outlook.com 0xc0000005 trying to open custom controls 0
How to import events VBA code in Excel? 2

Top