Thread: Module update
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Module update

Just change the name of the module:

ThisWorkbook.VBProject.VBComponents("Module31").Na me = "Module3"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Glen Mettler" wrote in message
...
Ron,
That's what I have done also. The problem is that the module
name ends up at Module31 instead of Module3. I need it to be
Module3 because that's what the update code in Module1 is
looking for. If it changes it to Module31, it will not find
Module3 the next time and I get an error.

Glen

"Glen Mettler" wrote in message
...
I have 3 modules - 1,2,3. Module1 contians code to delete and
then import module 3. It works just fine except that after the
import instead of Module3, I have Module31. How can I force
the name to Module3?

Glen