excel keeps crashing

  • Thread starter Thread starter kickyr
  • Start date Start date
K

kickyr

Hi,

I have a workbook that i am automating. After about a year of this i
have had to make a few more updates but i have a problem. Everytime i
try to create a new procedure
for example i just type in:

sub NewProcedure()

i get an error message that excel has created an erorr and will be shut
down.

I can do everything else, i can run all the other procedures and
everything but i can't add any more in.

I am using excel 2000 but when i try this on excel xp or 2003 it does
the same thing

i have tried to repair the file but that doesn't seam to work either. I
just think this is very weird. has anyone else had this problem?

i might just have to create a new workbook :(

cheers

stu
 
I have had that problem before. I found two solutions.
1. Export all your code. Import the code to a new
Workbook. Copy information in your sheets to the new
workbook. Sometimes it works to use the move/copy sheet
function (saves some time) but not always.
2. A lot easier but it will cost a little. There is a
utility called Excel Workbook Rebuilder (find it at
VBUser.com) that will rebuild your Workbook from scratch
and should fix the problem you are seeing.
Hope this helps,
Felix
-----Original Message-----

Hi,

I have a workbook that i am automating. After about a year of this i
have had to make a few more updates but i have a problem. Everytime i
try to create a new procedure
for example i just type in:

sub NewProcedure()

i get an error message that excel has created an erorr and will be shut
down.

I can do everything else, i can run all the other procedures and
everything but i can't add any more in.

I am using excel 2000 but when i try this on excel xp or 2003 it does
the same thing

i have tried to repair the file but that doesn't seam to work either. I
just think this is very weird. has anyone else had this problem?

i might just have to create a new workbook :(

cheers

stu


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
A strong caution that your workbook at this stage is very
susceptable to corrupting. Very soon you may not be able
to open it at all. I agree with the other posts that you
need to clean your code.

Regards,
Greg
-----Original Message-----

Hi,

I have a workbook that i am automating. After about a year of this i
have had to make a few more updates but i have a problem. Everytime i
try to create a new procedure
for example i just type in:

sub NewProcedure()

i get an error message that excel has created an erorr and will be shut
down.

I can do everything else, i can run all the other procedures and
everything but i can't add any more in.

I am using excel 2000 but when i try this on excel xp or 2003 it does
the same thing

i have tried to repair the file but that doesn't seam to work either. I
just think this is very weird. has anyone else had this problem?

i might just have to create a new workbook :(

cheers

stu


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
cheers guys, this worked great and now back to working properly. i
cleaned the code and its now working fine again

thanks again for all your help

cheers

stu
 
Back
Top