Opening Excel file from within ASP and passing variable into cell

[Lisa]

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]

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

Ray at work

"Lisa" <lisa.dunnette@btinternet.com> wrote in message
news:7acd7172.0306300207.1c0b17ba@posting.google.c om...

> 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