save Excel with a windows form

I have a windows form that traps an "before save" event in
Excel 2000. What I would like to do is save the Excel in
SQL Server by calling a web service. I thought I could
have serialized Excel and send it to the web service as a
string for database storage, but it seems that Excel
cannot be serialized. This windows form will be a no
touch deployment application so any extra software would
be difficult.

Any ideas?

Thanks,
Shane

hirf-spam-me-here
Fri Oct 24 15:31:13 CDT 2003

* "Shane Carter" <shane.carter@conocophillips.com> scripsit:
> I have a windows form that traps an "before save" event in
> Excel 2000. What I would like to do is save the Excel in
> SQL Server by calling a web service. I thought I could
> have serialized Excel and send it to the web service as a
> string for database storage, but it seems that Excel
> cannot be serialized. This windows form will be a no
> touch deployment application so any extra software would
> be difficult.

0% related to .NET Windows Forms programming. You may want to turn to
this group:

<news://news.microsoft.com/microsoft.public.dotnet.framework>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Chris
Fri Oct 24 22:27:54 CDT 2003

You can also send a byte array to a web service, so after the file was
saved, read it from disk (system.io.file) and send the file's bytes, and
store that in SQL Server. For a no touch deploy app to perform a disk read,
the security to the server must be full-trust, but I guess as you are using
automation, it is already the case.

"Shane Carter" <shane.carter@conocophillips.com> wrote in message
news:01f001c39a57$a8b1e950$a301280a@phx.gbl...
> I have a windows form that traps an "before save" event in
> Excel 2000. What I would like to do is save the Excel in
> SQL Server by calling a web service. I thought I could
> have serialized Excel and send it to the web service as a
> string for database storage, but it seems that Excel
> cannot be serialized. This windows form will be a no
> touch deployment application so any extra software would
> be difficult.
>
> Any ideas?
>
> Thanks,
> Shane
>
>
>

Chris
Fri Oct 24 22:29:09 CDT 2003

Why is it 0% related?

"Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> wrote in message
news:OvXrf3mmDHA.1676@TK2MSFTNGP09.phx.gbl...
> * "Shane Carter" <shane.carter@conocophillips.com> scripsit:
> > I have a windows form that traps an "before save" event in
> > Excel 2000. What I would like to do is save the Excel in
> > SQL Server by calling a web service. I thought I could
> > have serialized Excel and send it to the web service as a
> > string for database storage, but it seems that Excel
> > cannot be serialized. This windows form will be a no
> > touch deployment application so any extra software would
> > be difficult.
>
> 0% related to .NET Windows Forms programming. You may want to turn to
> this group:
>
> <news://news.microsoft.com/microsoft.public.dotnet.framework>
>
> --
> Herfried K. Wagner
> MVP · VB Classic, VB.NET
> <http://www.mvps.org/dotnet>

hirf-spam-me-here
Sat Oct 25 06:51:12 CDT 2003

* "Chris Botha" <chris_s_botha@AT_h.o.t.m.a.i.l.com> scripsit:
> Why is it 0% related?

It's an Excel event handling problem.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>