I spent about 8 hours coding a form, set the workbooks on open property to
show the form. Saved and closed the file, when I re-opened I get System Error
&H8000FFF Catastrophic Failure. Using XL V. 11.8146.8132. The repaired file
shows an error log that says 'lost vb project' and my form is gone. Are
excels vb forms totally unreliable or was it something else?

Did you exit Excel, reopen Excel and try to open your file again? Sometimes
that message only applies to what was in memory, not the disc file.

"headly" wrote:

> I spent about 8 hours coding a form, set the workbooks on open property to
> show the form. Saved and closed the file, when I re-opened I get System Error
> &H8000FFF Catastrophic Failure. Using XL V. 11.8146.8132. The repaired file
> shows an error log that says 'lost vb project' and my form is gone. Are
> excels vb forms totally unreliable or was it something else?

Gone, lost forever. Was likely the result of:

A live data odbc connection

Connected to the form, which used a chart that was being dynamically updated
by the live odbc connection. When the workbook opened, the odbc wasn't yet
refreshed and the chart tried to draw.

But darn, losing all my code for 1 flakey msft error, that's not fair.

"JLGWhiz" wrote:

> Did you exit Excel, reopen Excel and try to open your file again? Sometimes
> that message only applies to what was in memory, not the disc file.
>
> "headly" wrote:
>
> > I spent about 8 hours coding a form, set the workbooks on open property to
> > show the form. Saved and closed the file, when I re-opened I get System Error
> > &H8000FFF Catastrophic Failure. Using XL V. 11.8146.8132. The repaired file
> > shows an error log that says 'lost vb project' and my form is gone. Are
> > excels vb forms totally unreliable or was it something else?

I have a CD that stores my back up files. You might want to consider using a
backup disc as you complete a project milestone.

"headly" wrote:

> Gone, lost forever. Was likely the result of:
>
> A live data odbc connection
>
> Connected to the form, which used a chart that was being dynamically updated
> by the live odbc connection. When the workbook opened, the odbc wasn't yet
> refreshed and the chart tried to draw.
>
> But darn, losing all my code for 1 flakey msft error, that's not fair.
>
> "JLGWhiz" wrote:
>
> > Did you exit Excel, reopen Excel and try to open your file again? Sometimes
> > that message only applies to what was in memory, not the disc file.
> >
> > "headly" wrote:
> >
> > > I spent about 8 hours coding a form, set the workbooks on open property to
> > > show the form. Saved and closed the file, when I re-opened I get System Error
> > > &H8000FFF Catastrophic Failure. Using XL V. 11.8146.8132. The repaired file
> > > shows an error log that says 'lost vb project' and my form is gone. Are
> > > excels vb forms totally unreliable or was it something else?