missing modules in personal.xls

  • Thread starter Thread starter maver
  • Start date Start date
M

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
 
My first guess is that you're looking at two different files (in different
folders) that happen to share the same name.
 
My first guess is that you're looking at two different files (in different
folders) that happen to share the same name.
Click to expand...

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
 
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.
 
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)
 
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.
 
Do you think that there might be a chance that an overzealous antivirus
program
Click to expand...

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)
 
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!).

Chip said:
Do you think that there might be a chance that an overzealous antivirus
program
Click to expand...

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)
Click to expand...
 
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!).
Click to expand...

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
 
Back
Top