Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
arrays - module to module mike Excel Programming 3 February 25th 04 08:56 PM
Update VBA Module Code Todd Huttenstine[_2_] Excel Programming 1 December 27th 03 10:15 AM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"