Macros name changing.

**Mordred** · 08-10-2010, 10:14 AM

Hi all,
I have a problem with how Excel is naming my macros. For the most part, the name that I enter is used. For instance:

I have many provincial updates with the following naming schemes.
MBCPI
BCCPI
....
The problem is, I have a line now that says this:
CopyCPI.xls!ProvCPIUpdate.ProvCPIUpdate
It should only read: ProvCPIUpdate because that is the name that I named it.
Any ideas?

Thanks.

**Whizbang** · 08-10-2010, 10:20 AM

It depends on what is the active workbook. If you have two or more workbook open, it will list all the available macros, but will add on the workbook and module name to identify the source. If you only have the workbook with the macro desired open, it will display as you named it.

**Mordred** · 08-10-2010, 10:24 AM

Thanks Whizbang, I've noticed that when there is more than one workbook open but I only have one open, and the macro belongs to it. Mayhap it is some sort of glitch in Excel? Plus, I only see it named that way on the list that comes up when I click on the run button from the macros toolbar.

**Whizbang** · 08-10-2010, 10:28 AM

Do you have any macros saved in your personal.xls workbook? Maybe that is what is causing it to rename.

**Edit**

I just ran a test. Please disregard all of my mis-informed posts. It is renaming it for me as well. Huh. I never noticed that.

**Whizbang** · 08-10-2010, 10:34 AM

I found this link, which says that it is just the way it is.

http://answers.yahoo.com/question/in...5214231AAnFUDh

**romperstomper** · 08-10-2010, 10:38 AM

Re CopyCPI.xls!ProvCPIUpdate.ProvCPIUpdate
That means you have put the macro named ProvCPIUpdate into a module also named ProvCPIUpdate. You should NEVER do that.

**Mordred** · 08-10-2010, 10:40 AM

I totally understand the logic if there are more than one macro with the same name but I haven't created another macro with that specific name. Oh well, it doesn't change how the program is run, it is a pain however if I use that particular sub in another sub because I have to call it by its display name instead of just ProvCPIUpdate. Thanks Whizbang.

**Mordred** · 08-10-2010, 10:42 AM

Hi romperstomper, I haven't done that though, this is my sub:

Please Login or Register  to view this content.

**Whizbang** · 08-10-2010, 10:46 AM

No, what he is saying is that you created a module called "ProvCPIUpdate" and then within that module you created a subroutine called "ProvCPIUpdate". This is not the recommended practice.

Also, you CAN call the sub by the name ProvCPIUpdate, as long as the sub is not private to the module.

For instance, put this code in another module in the workbook and then run it.

Please Login or Register  to view this content.

**Mordred** · 08-10-2010, 11:24 AM

Thanks Whizbang and romperstomper, you two nailed it. My module and sub were named the same. I renamed my module and now its all good.

Macros name changing.

LinkBack

Thread Tools

Rate This Thread

Display

Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Re: Macros name changing.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions