Running Excel on the Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sylvia
    #1

    Running Excel on the Server

    Dear All,

    Would appreciate if someone can help me out on this.

    I have an Excel Add-in which is only available on the web server.
    The Add-in allows user to retrieve data from a proprietary database.

    I have configured an Excel workbook to retrieve the data via the Add-in base
    on some inputs that the user enter in some cells (B7 and B8) in sheet1.

    As the clients do not have the Add-in I cannot just activate the Excel
    spreadsheet when the user request for it over the web as the formulas will
    not work.

    I have written a macro in the Excel spreadsheet such that it will
    recalculate and then make a static copy of itself.

    I would like to know how I can pass the values from an asp page to cells B7
    and B8 and then run the macro in the Excel and display the static copy for
    the user.

    Any suggestions are welcome.

    Thanks a lot!

    Newbie to ASP,
    Sylvia



    Tags: None
    • Brynn
      #2
      Re: Running Excel on the Server

      changing the excel sheet should be easy enough with ASP ... just like
      any other db connection ...

      as far as running a macro there are threads in google about this ...

      http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=udjHb1FPCHA.2684%40tkmsftngp08&rnum=6&prev=/groups%3Fas_q%3Dasp%2520excel%2520macro%26safe%3Dimages%26ie%3DUTF-8%26oe%3DUTF-8%26as_drrb%3Db%26as_mind%3D12%26as_minm%3D5%26as_miny%3D2002%26as_maxd%3D8%26as_maxm%3D1%26as_maxy%3D2004%26lr%3D%26hl%3Den


      one for example

      after the macro is done, reading the static excel page should be easy
      enough.


      On Thu, 8 Jan 2004 15:21:12 +0800, "Sylvia" <anghy@nospam.c se.com.sg>
      wrote:
      [color=blue]
      >Dear All,
      >
      >Would appreciate if someone can help me out on this.
      >
      >I have an Excel Add-in which is only available on the web server.
      >The Add-in allows user to retrieve data from a proprietary database.
      >
      >I have configured an Excel workbook to retrieve the data via the Add-in base
      >on some inputs that the user enter in some cells (B7 and B8) in sheet1.
      >
      >As the clients do not have the Add-in I cannot just activate the Excel
      >spreadsheet when the user request for it over the web as the formulas will
      >not work.
      >
      >I have written a macro in the Excel spreadsheet such that it will
      >recalculate and then make a static copy of itself.
      >
      >I would like to know how I can pass the values from an asp page to cells B7
      >and B8 and then run the macro in the Excel and display the static copy for
      >the user.
      >
      >Any suggestions are welcome.
      >
      >Thanks a lot!
      >
      >Newbie to ASP,
      >Sylvia
      >
      >
      >[/color]

        Comment

        Previous template Next
        Working...