excel erroring out

I

icestationzbra

hi,

i have a workbook with several macros in it, size is about 2 mb, ha
about 6 sheets, couple of images.

i have been using this for the past 9 months without any problem
suddenly, in the last few days, when i open this file and then open an
other excel file, excel errors out and closes both the files. i have no
clue why this is happening. any guesses?

i cannot give any more information on this situation, as i cant figur
anything else out. help towards a solution will be grately appreciated
as it is harassing quite a few users.

thanks,

mac
 
G

Guest

something change. a file doen't work ok for nine month and
then just start messing up for no reason.
does the same error occur when you open the first file
second.
grill the users about what one of them may have done to
the file.
i have no idea what is wrong. but something changed.
 
L

Lady Layla

Reboot
Delete all files in your c:\windows\temp directory and c:\documents &
settings\<user name>\local settings\temp directory
Restart Excel, see if you can open the file


message : hi,
:
: i have a workbook with several macros in it, size is about 2 mb, has
: about 6 sheets, couple of images.
:
: i have been using this for the past 9 months without any problem.
: suddenly, in the last few days, when i open this file and then open any
: other excel file, excel errors out and closes both the files. i have not
: clue why this is happening. any guesses?
:
: i cannot give any more information on this situation, as i cant figure
: anything else out. help towards a solution will be grately appreciated,
: as it is harassing quite a few users.
:
: thanks,
:
: mac.
:
:
: ---
:
:
 
I

icestationzbra

hi,

i dont mean to sound/be arrogant at all... i consider myself an advanc
user of computers and excel. i have tried to figure everything els
out.

this file is a parent file. lot of people copy this file onto thei
respective computers, fill data, and then use macros to copy thei
respective data onto the "central" file. this has been going on for th
last 9 months, without a hitch. only in the last 2 weeks, people hav
started complaining. and nobody can make any changes, except for th
data. i am the "central" file's administrator. when i open the file,
do not get any error. when someone else opens it, while their persona
file is open, they get the error. it is baffling, to say the least
when i copy one of the user's files, open it, and then open the centra
file, i get the error. they could not have made any changes as they ar
not *savvy* enough to have done it. i know it for the past 9 months.

it has got my goat.

clueless as i could be,

mac
 
L

Lady Layla

It seems to have also gotten your Shift key too.




message : hi,
:
: i dont mean to sound/be arrogant at all... i consider myself an advance
: user of computers and excel. i have tried to figure everything else
: out.
:
: this file is a parent file. lot of people copy this file onto their
: respective computers, fill data, and then use macros to copy their
: respective data onto the "central" file. this has been going on for the
: last 9 months, without a hitch. only in the last 2 weeks, people have
: started complaining. and nobody can make any changes, except for the
: data. i am the "central" file's administrator. when i open the file, i
: do not get any error. when someone else opens it, while their personal
: file is open, they get the error. it is baffling, to say the least.
: when i copy one of the user's files, open it, and then open the central
: file, i get the error. they could not have made any changes as they are
: not *savvy* enough to have done it. i know it for the past 9 months.
:
: it has got my goat.
:
: clueless as i could be,
:
: mac.
:
:
: ---
:
:
 
I

icestationzbra

hello lady,

i did not get what you meant by "shift key" in your response. i coul
not understand whether it was an insinuation of a banter, or pointin
towards a direction where i could seek a remedy.

mac
 
D

Dave Peterson

I think that Lady Layla was commenting on you lack of upper case in your
message. But e.e. cummings did ok.

Maybe your workbook is on the cusp of corruption. Do you run different versions
of excel?

I've never used OpenOffice, but some people have written that opening the
workbook in OpenOffice and saving it, may help clean up corruption. (Although,
if it is corrupted, you may lose something--formatting???)

You may want to try it.
http://www.openoffice.org, a 60-65 meg download or a CD

Or if the workbook isn't too complex, could you rebuild it and see if that
helps?
 
I

icestationzbra

hi dave,

:), i seem to be quite a village bum when it comes to these things,
but i could not figure out what is e. e. cummings. i do not use upper
case at all when i write an email, or a post, or anything related to
internet for that matter. i type very fast, and make less mistakes in
spelling (which is my priority), if i do not use the shift key.

the file was originally created on xl 2k2 xp. some of the functions
were not portable from that version on to xl 2k. so, some changes had
to be made, as the client computers are all on office 2k. i have even
forgotten what were the changes that were made in order for the sheet
to run on office 2k. so i cant figure out what might be causing the
problem. usually, whatever improvements i make to this file, i take it
to the client's pc and run it once. there, i have to change certain
things in order for it to work. when that works, i figure that it
should not crash at a later date. it has me baffled. the other thing
is, it does not give a clue as to what the problem could be, as it does
not provide any error number.

thanks,

mac.
 
D

Dave Peterson

First, the important stuff:
http://www.americanpoems.com/poets/eecummings/
http://en.wikipedia.org/wiki/Cummings

He seemed to find puncuation and capitalization rules more suggestions than
rules.

I think crashes are pretty difficult to diagnose. You could try that openoffice
suggestion, but before you do that, try Rob Bovey's code cleaner:

http://www.appspro.com/

Sometimes, there's (invisible) junk left over in the VBA modules. Rob Bovey's
code cleaner exports the modules, deletes them and then reimports the modules.

(You could do the same thing manually.)

But you still might be stuck rebuilding the workbook.

Good luck,
 
I

icestationzbra

hi dave,

i will be going to cummings first, and then on to bovey :), may b
cummings has suggestions for coding rules :-D...

thanks, i am looking through the stuff, i hope i can get the erro
fixed.

mac
 
I

icestationzbra

hi dave,

i have not tried the 'bovey' utility on all the files, but whicheve
files i have tried it on, they are functioning correctly. surprisingly
they have become faster! it was a pleasant surprise. can you tell me ho
it is able to improve the speed and what is the underlying concep
behind that utility? from what i figured out, it removes all the macro
and then pastes them back. how does that make a difference?

thanks for the utility,

regards,

mac
 
D

Dave Peterson

I'm not sure why they work faster. I would have guessed that the first time you
ran the code, it would actually be a little slower.

VBA isn't a compiled language. The first time the code is run, it's converted
to p-code (some sort of operation codes). Then that version is run. So I would
have guessed that the first time it's run would actually slow it down.

You can read some notes by Don Baarns (much better than I could explain) at:
http://archive.baarns.com/excel/develop/vbaperfm.asp


And for some reason, excel/VBA doesn't do a terrific job of housecleaning.
Sometimes there's junk left behind after you make changes.

If you have a big project, compile it (yeah, it's not really compiled!) via:
Debug|compile VBAProject

Then save it as a copy.

Then run Rob Bovey's code cleaner.
Then save it as a different named copy.

Then to windows explorer and look at the file size.

===
And you hit the nail on the head. You could do the exporting, deleting and
reimporting for each module if you want manually. The VBACodeCleaner just(!)
makes it a lot easier (and therefore, more likely to be used??).

Rob code cleaner is often suggested to fix mysterious errors--when the code
looks ok.
 
Top