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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.

Check out Rob Bovery's Code Cleaner, which does all those things -
automated! If it crahses, clean the workbook with macros disabled.
www.appspro.com

Alex J


"Felix" wrote in message
...
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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements