> Hi,
> i am trying to save some data in a excel spreadsheet, whenever the programm
> shuts down.
> Mostly this happens when a user is logging off or shuts the computer down.
> im am using the
> Private Sub Form1_Closing(ByVal sender As Object, ByVal e As
> System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
> to save the data before the shutdown.
> The problem is that i can't open excel. Windows is prompting that it can't
> close my programm. And i am getting
> some error messages like error code 800800005. Which is leading me to am MS
> Website but that's not solving
> my problem. Is there a chance to open excel somehow while windows is
> shutting down, or do i have to save my data
> in a different way?
>
> thanks in advance
> chris knievel

> I would save your data quickly to text, and then next time app starts
> up read this into excel?
> Chris Knievel wrote:
>> Hi,
>> i am trying to save some data in a excel spreadsheet, whenever the
>> programm
>> shuts down.
>> Mostly this happens when a user is logging off or shuts the computer
>> down.
>> im am using the
>> Private Sub Form1_Closing(ByVal sender As Object, ByVal e As
>> System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
>> to save the data before the shutdown.
>> The problem is that i can't open excel. Windows is prompting that it
>> can't
>> close my programm. And i am getting
>> some error messages like error code 800800005. Which is leading me to
>> am MS
>> Website but that's not solving
>> my problem. Is there a chance to open excel somehow while windows is
>> shutting down, or do i have to save my data
>> in a different way?
>> thanks in advance
>> chris knievel

> Hello dermot,
>
> I would subclass the window procedure and trap the request to shutdown/restart
> message.  Return whatever value is required to abort the shutdown.  Do your
> dealio with excel, then initiate a second shutdown request prgrammatically.
>
> -Boo
>
> > I would save your data quickly to text, and then next time app starts
> > up read this into excel?
> > Chris Knievel wrote:
> >> Hi,
> >> i am trying to save some data in a excel spreadsheet, whenever the
> >> programm
> >> shuts down.
> >> Mostly this happens when a user is logging off or shuts the computer
> >> down.
> >> im am using the
> >> Private Sub Form1_Closing(ByVal sender As Object, ByVal e As
> >> System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
> >> to save the data before the shutdown.
> >> The problem is that i can't open excel. Windows is prompting that it
> >> can't
> >> close my programm. And i am getting
> >> some error messages like error code 800800005. Which is leading me to
> >> am MS
> >> Website but that's not solving
> >> my problem. Is there a chance to open excel somehow while windows is
> >> shutting down, or do i have to save my data
> >> in a different way?
> >> thanks in advance
> >> chris knievel