Opening Excel file from within ASP and passing variable into cell

Discussion in 'ASP General' started by Lisa, Jun 30, 2003.

  1. Lisa

    Lisa Guest

    I have an excel file on my server, which contains an embedded query. I
    want to be able to open the excel file, pass the contents of my
    variable into a cell within the worksheet and then refresh the query
    based on the variable passed.

    I can get the query part to work. The bit I can't get to work is where
    I open the excel file and pass the variable into a cell. I have tried
    various things and although excel launches without error, I can't see
    my file in the excel window.

    Any ideas?

    Thanks in advance,
    Lisa
     
    Lisa, Jun 30, 2003
    #1
    1. Advertising

  2. Lisa

    Ray at Guest

    What code are you using to launch Excel? Show that please. Are you using
    ADO or the Excel object?

    Ray at work

    "Lisa" <> wrote in message
    news:...
    > I have an excel file on my server, which contains an embedded query. I
    > want to be able to open the excel file, pass the contents of my
    > variable into a cell within the worksheet and then refresh the query
    > based on the variable passed.
    >
    > I can get the query part to work. The bit I can't get to work is where
    > I open the excel file and pass the variable into a cell. I have tried
    > various things and although excel launches without error, I can't see
    > my file in the excel window.
    >
    > Any ideas?
    >
    > Thanks in advance,
    > Lisa
     
    Ray at, Jun 30, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Phillip Roncoroni
    Replies:
    14
    Views:
    1,113
    Toby A Inkster
    Apr 5, 2004
  2. Replies:
    1
    Views:
    1,805
    extentechjohn
    Nov 21, 2006
  3. Jonas Daunoravicius
    Replies:
    5
    Views:
    325
    Peter
    Jul 17, 2003
  4. fniles
    Replies:
    0
    Views:
    282
    fniles
    Apr 26, 2009
  5. Jonas Daunoravicius
    Replies:
    5
    Views:
    295
    Peter
    Jul 17, 2003
Loading...

Share This Page