missing modules in personal.xls

[maver]

Hi All,

I have problem with some of the macros in modules missing in
personal.xls . I have multiple macros in multiple modules in my
personal.xls. When I try to make a copy of the personal.xls on the
same machine, the new copy of the personal.xls has some modules
missing in it (with the first personal.xls closed ). I am not able to
figure out what the problem is . Please help me out as its a bit
urgent.

-Thanks in advance
RC

 

[Dave Peterson]

My first guess is that you're looking at two different files (in different
folders) that happen to share the same name.

 

[maver]

My first guess is that you're looking at two different files (in different
folders) that happen to share the same name.

Hello Dave,

Here is what I did.... I have copied the personal.xls and pasted it in
another directory then renamed it a s personal1.xls . When I open the
personal1.xls it is missing some of the macros which are there in the
original personal.xls. I dont know whats going wrong here.

Please help me
-RC

 

[Dave Peterson]

Use windows start button|search to look for all personal.xls. Maybe one of the
other files is the one that had all the modules.

 

[Chip Pearson]

On a commercial application (just an xls) I wrote for a firm in Canada, we
have had a handful of reports from users that suddenly and without warning
all the VBA code is simply deleted. Completely gone, without a trace. I am
convinced that somewhere deep in the bowels of VBA there is a bizarre set of
circumstances that if all are true and the moon is in the right phase, the
VBA gets deleted.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Dave Peterson]

Do you think that there might be a chance that an overzealous antivirus program
could be deleting modules and allowing other modules to live?

I've never seen anything like this or what you describe, though.

 

[Chip Pearson]

Do you think that there might be a chance that an overzealous antivirus

program

We looked into that with 2 different users (one with McAfee and one with
Norton) and got nowhere. It is true, though, that if the VBA code contains
a reference to the VBIDE Extensibility Library, some virus checkers will
delete all the code. I learned that one the hard way.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Dave Peterson]

I've read the same kind of reports here in the newsgroups--but none that say
some modules are kept and others are deleted (well, according to my memory!).

Do you think that there might be a chance that an overzealous antivirus
program

We looked into that with 2 different users (one with McAfee and one with
Norton) and got nowhere. It is true, though, that if the VBA code contains
a reference to the VBIDE Extensibility Library, some virus checkers will
delete all the code. I learned that one the hard way.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[maver]

I've read the same kind of reports here in the newsgroups--but none that say
some modules are kept and others are deleted (well, according to my memory!).

Hi Dave,Chip,

I was able to figure what the problem was. Excel was storing the copy
of my personal.xls in this location c:/documentsettings/user/
ApplicationData/Microsoft/Excel/XLSTART/personal.xls . So what ever
changes I have made its reflected in this copy. I should have searched
it in the first place. lesson learnt

Thanks
RC