module name changes on it's own

I am stumped.

I have an auto_open macro that (with help from a number of people on this forum) I now have self-maintaining.

If a flag in the workbook is set to "Y" then the module (that also contains the auto_open) is removed and a new version is imported.
This works. A treat.

The problem is that SOMETIMES (well - often) the newly importing module name has a "1" added to it.

So module deleted might be FRED.
Module loaded is FRED.
Module name is set to FRED1.

Of course, next time someone loads new version it cannot find FRED (as it is now called FRED1).

Can anyone point me in the direction of the problem?

Thanks in advance.

What code are you using? Is it deleting Fred before adding the new code?

Why can't you codee just edit the existing module?

a link to your previous post might help.

I've a sneaking suspicion I may have worked it out.
In non-technical terms this is what I think is happening ...

FRED is a module.
Within FRED there is an AUTO_OPEN procedure wheich checks a flag on the spreadsheet and if the flag is "Y" it then removes the module FRED and imports FRED from a file (the location of which is also specified on the spreadsheet).

I think that FRED is being executed so when FRED is imported, it cannot be called FRED as FRED is executing at that timem so Excel helpfully calls it FRED1.

The code, in case it helps people much more skilled than I, I use to do this is as follows ...

Please Login or Register  to view this content.

The variables used above are ...
vReloadCodeOnStartup = the flag to decide whether new load is required.
vFileContainingModule = The file name where the new version can be found
vModuleToLoad = the module name (e.g. FRED)

ANY comments on this welcome.
BTW - the module is not really called FRED (in case it matters), I've changed the name to protect company confidentiality.

I guess I could rename the "old" module prior to removal - would that do it?
If so - how would I rename it?

Again - thanks very much for your help.

Can anyone tell me how I can use VBA to rename a module?

Thanks

Hi tonywig

How about :

Please Login or Register  to view this content.

HTH

DominicB

Thanks Dominic