EXCEL CRASHES

I am running office 2007 on a Dell Dimention 9200
I run a lot of VBA behind my spreadsheets which are also linked to a
"Person" file.
Over a perion of several months, with my office system shutting down about 4
times a day, I have noticed that it is nearly always when I save a file,
either manually or via VBA. It seems the file also gets delinked from the VB
application.
All my code will compile OK - never any errors and yet I have one file which
I know will crash every time I save it. Can anyone suggest a solution short
of removing all the VB.

Maybe a post in microsoft.public.excel or microsoft.public.excel.programming
would be a better place to post.


"Tony" <> wrote in message
news:670F7637-6A45-4F5C-ADD0-...
>I am running office 2007 on a Dell Dimention 9200
> I run a lot of VBA behind my spreadsheets which are also linked to a
> "Person" file.
> Over a perion of several months, with my office system shutting down about
> 4
> times a day, I have noticed that it is nearly always when I save a file,
> either manually or via VBA. It seems the file also gets delinked from the
> VB
> application.
> All my code will compile OK - never any errors and yet I have one file
> which
> I know will crash every time I save it. Can anyone suggest a solution
> short
> of removing all the VB.

Thanks Bill - I will give it a go.


"Bill Yanaire" wrote:

> Maybe a post in microsoft.public.excel or microsoft.public.excel.programming
> would be a better place to post.
>
>
> "Tony" <> wrote in message
> news:670F7637-6A45-4F5C-ADD0-...
> >I am running office 2007 on a Dell Dimention 9200
> > I run a lot of VBA behind my spreadsheets which are also linked to a
> > "Person" file.
> > Over a perion of several months, with my office system shutting down about
> > 4
> > times a day, I have noticed that it is nearly always when I save a file,
> > either manually or via VBA. It seems the file also gets delinked from the
> > VB
> > application.
> > All my code will compile OK - never any errors and yet I have one file
> > which
> > I know will crash every time I save it. Can anyone suggest a solution
> > short
> > of removing all the VB.
>
>
>

::Hi, :

::Maybe it is your file that leads to crash. I think you can try
utility called Advanced Excel Repair to repair your Excel xls file. I
works rather well for my corrupt Excel xls files. Its web address i
'Advanced Excel Repair - Repair corrupt Excel files. Fix Excel files.
(http://www.datanumen.com/aer/) :
::::
::Hope this helps.:

::Alan:

--
fy
Posted via http://www.vistaheads.co