Posted by NC on 08/10/07 21:23

On Aug 10, 11:06 am, Louis <t051...@hotmail.com> wrote:
>
> I missed mentioning that the whole application starts
> from the web. I have to trigger this Excel update operation
> through a button on the web form.

Er, something doesn't make sense here. The Excel spreadsheet that
needs updating resides on Computer A. The Web application and its
data reside on Computer B. If you want data updated on Computer A,
but trigger this update from Computer B, Computer B needs read-write
access to Computer A (read to get the existing spreadsheet, write to
update it)... Can you provide it?

In actual systems (Bloomberg Excel API comes to mind), the initiative
usually comes from within an Excel spreadsheet. You write an add-on
that implements one or more custom spreadsheet functions; every time
the spreadsheet is opened (or even in real-time, if you prefer), the
add-on connects to your Web service and retrieves the data requested
by cells containing the calls to custom functions...

Cheers,
NC

[Back to original message]