Hi Mike,
With asp and an IIS server you can create Excel files and use them as a com object to accomplish what you want.
See the links in this thread.
http://www.google.com/groups?hl=en&...s&ie=UTF-8&oe=UTF-8&as_uauthors=jaf&lr=&hl=en
--
John
johnf 202 at hotmail dot com
"Mike" <mike4532> wrote in message | I have an Access dbase. Everything, reading, writing, deleting, etc.. is
| done from our company intranet using ASP pages.
|
| I also have an excel spreadsheet that pulls data from that same dbase.
|
| On that spreadsheet, there is a cell that I put a number in, that references
| a record in my dbase. Once that number is put in the spreadsheet, it queries
| the dbase and pulls that record's information in.
|
| I then run the calculations on the spreadsheet, etc........
|
| Right not we are having to find the record we need on the intranet, copy the
| record number, open the spreadsheet, and paste the record number so it will
| query the dbase.
|
| I would like to make a link on the site that will essentially copy that
| record number, open the file and past it into the cell.
|
| Would something like this be possible?
|
| Mikeal
|
| | > > Okay....Then, can you copy something to your Clip Board by clicking a
| > link?
| >
| > No. Perhaps if you can tell us what your requirement is (what you want
| your
| > program to accomplish, in general terms), we can help you come up with a
| > viable solution.
| >
| > --
| > HTH,
| > Kevin Spencer
| > .Net Developer
| > Microsoft MVP
| > Big things are made up
| > of lots of little things.
| >
| > "Mike" <mike4532> wrote in message
| > | > > Okay....Then, can you copy something to your Clip Board by clicking a
| > link?
| > >
| > >
| > > | > > > Hi Mike,
| > > >
| > > > If the user has Excel installed, a link to an .xls document will
| > download
| > > > the file and load it into Excel. And no, you can't pass a parameter to
| > it.
| > > >
| > > > --
| > > > HTH,
| > > > Kevin Spencer
| > > > .Net Developer
| > > > Microsoft MVP
| > > > Big things are made up
| > > > of lots of little things.
| > > >
| > > > "Mike" <mike4532> wrote in message
| > > > | > > > > Can you open Excel on the local machine when you click a hyperlink
| in
| > a
| > > > web
| > > > > page?
| > > > >
| > > > > If so....Can you also pass a parameter from the web page into a cell
| > in
| > > > > excel.?
| > > > >
| > > > > Mikeal
| > > > >
| > > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
|
