fair enough, I suppose

-----Original Message-----
From: Joe Fawcett [mailto:joefawcett@h...]
Sent: 21 November 2001 13:48
To: javascript
Subject: [javascript] Re: open excel and put in data


You must be joking. You could use the power of VBA in Excel to do just about

anything once you were allowed to open it.

Regards

Joe Fawcett



>From: "Alex Shiell, ITS, EC, SE" <alex.shiell@s...>
>Reply-To: "javascript" <javascript@p...>
>To: "javascript" <javascript@p...>
>Subject: [javascript] Re: open excel and put in data
>Date: Tue, 20 Nov 2001 11:23:07 -0000
>
>great, thanks
>
>I would have thought that Excel would be marked as safe though!
>
>-----Original Message-----
>From: O'Hara, Elliott M [mailto:EMOHARA@k...]
>Sent: 20 November 2001 11:14
>To: javascript
>Subject: [javascript] Re: open excel and put in data
>
>
>tools-->internet options-->custom
>set the first 5 (all the Active x)
>to enabled
>and make sure your site is a member of the zone that you just set
>
>should work for ya
>
>-----Original Message-----
>From: Alex Shiell, ITS, EC, SE [mailto:alex.shiell@s...]
>Sent: Tuesday, November 20, 2001 5:34 AM
>To: javascript
>Subject: [javascript] Re: open excel and put in data
>
>
>Thanks for all your help folks, its working great now.
>
>If anyone knows how to stop that message coming up to confirm wether you
>want to allow the ActiveX object to run, that would be ideal.  My
>application is in "Trusted Sites" and security is set to "Low".
>
>-----Original Message-----
>From: Alex Shiell, ITS, EC, SE
>Sent: 19 November 2001 17:06
>To: javascript
>Subject: [javascript] Re: open excel and put in data
>
>
>Yes, that would be good thanks - although i am getting somewhere by opening
>a blank workbook and pasting the data in, which is almost working properly
>(well it works great on my machine with IE5.5 and XL2000, but not so great
>for the rest of the company on IE5 and XL97)
>
>-----Original Message-----
>From: Joe Fawcett [mailto:joefawcett@h...]
>Sent: 19 November 2001 16:08
>To: javascript
>Subject: [javascript] Re: open excel and put in data
>
>
>Excel can read HTML tables so you can just save the outerHTML of the table,
>add some surrounding html and body tags and asave it to a temporary file.
>Then open Excel with that file. I have exactly this code on our intranet
>site if you want it.
>
>
>Regards
>
>Joe Fawcett
>
>
>
> >From: "Alex Shiell, ITS, EC, SE" <alex.shiell@s...>
> >Reply-To: "javascript" <javascript@p...>
> >To: "javascript" <javascript@p...>
> >Subject: [javascript] Re: open excel and put in data
> >Date: Mon, 19 Nov 2001 11:22:57 -0000
> >
> >thanks - this is an intranet application so everyone has Excel and has a
> >lcense for it, no problem there.
> >
> >Does this mean I would have to put each piece of data into cells
> >intividually?  Thats not much good... I'll see if theres a method that
> >allows you to shove in a whole screen's worth of HTML.
> >
> >-----Original Message-----
> >From: DANIEL RADU [mailto:radudanielro@y...]
> >Sent: 19 November 2001 11:04
> >To: javascript
> >Subject: [javascript] Re: open excel and put in data
> >
> >
> >
> >You can do this. But, you have to be sure that the client has excel
> >installed (and I think it's a problem with the licenses too).
> >
> >
> >Anyway, you could use the ActiveXObject object;
> >
> >
> >function runExcel()
> >{
> >   try
> >   {
> >     var oExcel = new ActiveXObject("Excel.Application"); // or
> >Excel.Workbook ... (I'm not sure)
> >     oExcel.visible = true;
> >   }
> >   catch(e)
> >   {
> >     alert(e.description);
> >   }
> >}
> >
> >The export is not difficult, but you have to know to access the cells of
> >the
> >excel. There some properties and methods of the excel object model that
> >allow to do this.
> >
> >Good luck!
> >
> >   "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> wrote:
> >
> >
> >Is there a way to open Excel from a button in the browser and import the
> >HTML from the currently displayed page into it?
> >
> >I can do this by creating a new request for the same page and setting the
> >response content-type to "application/vnd.ms-excel", but ideally I'd like
> >to
> >do this from the client to save having to fetch the data from the server
> >again.
> >
> >________________________________________________________________________
> >Scottish Enterprise Network
> >http://www.scottish-enterprise.com
> >
> >Headquarters Address & Contact Numbers
> >
> >150 Broomielaw
> >5 Atlantic Quay
> >Glasgow
> >G2 8LU.
> >Tel: +44 (0) 141 248 2700.
> >Fax: +44 (0)141 221 3217
> >
> >This message is sent in confidence for the addressee only.
> >It may contain legally privileged information. The contents are not to
> >be disclosed to anyone other than the addressee. Unauthorised recipients
> >are requested to preserve this confidentiality and to advise the sender
> >immediately of any error in transmission.
> >
> >
> >
$subst('Email.Unsub')
> >
> >
> >
> >
> >
> >    _____
> >
> >Do You Yahoo!?
> >Find the one for you at Yahoo!
> ><http://rd.yahoo.com/mktg/mail/txt/tagline/?http://personals.yahoo.com>
> >Personals. --- 
> >alex.shiell@s... 
> >$subst('Email.Unsub')
> >
> >
> >________________________________________________________________________
> >Scottish Enterprise Network
> >http://www.scottish-enterprise.com
> >
> >Headquarters Address & Contact Numbers
> >
> >150 Broomielaw
> >5 Atlantic Quay
> >Glasgow
> >G2 8LU.
> >Tel:  +44 (0) 141 248 2700.
> >Fax:  +44 (0)141 221 3217
> >
> >  This message is sent in confidence for the addressee only.
> >It may contain legally privileged information. The contents are not to
> >be disclosed to anyone other than the addressee. Unauthorised recipients
> >are requested to preserve this confidentiality and to advise the sender
> >immediately of any error in transmission.
> >
> >
> >
> >
$subst('Email.Unsub')
> >
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
>
>________________________________________________________________________
>Scottish Enterprise Network
>http://www.scottish-enterprise.com
>
>Headquarters Address & Contact Numbers
>
>150 Broomielaw
>5 Atlantic Quay
>Glasgow
>G2 8LU.
>Tel:  +44 (0) 141 248 2700.
>Fax:  +44 (0)141 221 3217
>
>  This message is sent in confidence for the addressee only.
>It may contain legally privileged information. The contents are not to
>be disclosed to anyone other than the addressee. Unauthorised recipients
>are requested to preserve this confidentiality and to advise the sender
>immediately of any error in transmission.
>
>
>
>
>________________________________________________________________________
>Scottish Enterprise Network
>http://www.scottish-enterprise.com
>
>Headquarters Address & Contact Numbers
>
>150 Broomielaw
>5 Atlantic Quay
>Glasgow
>G2 8LU.
>Tel:  +44 (0) 141 248 2700.
>Fax:  +44 (0)141 221 3217
>
>  This message is sent in confidence for the addressee only.
>It may contain legally privileged information. The contents are not to
>be disclosed to anyone other than the addressee. Unauthorised recipients
>are requested to preserve this confidentiality and to advise the sender
>immediately of any error in transmission.
>
>
>
>
>
>________________________________________________________________________
>Scottish Enterprise Network
>http://www.scottish-enterprise.com
>
>Headquarters Address & Contact Numbers
>
>150 Broomielaw
>5 Atlantic Quay
>Glasgow
>G2 8LU.
>Tel:  +44 (0) 141 248 2700.
>Fax:  +44 (0)141 221 3217
>
>  This message is sent in confidence for the addressee only.
>It may contain legally privileged information. The contents are not to
>be disclosed to anyone other than the addressee. Unauthorised recipients
>are requested to preserve this confidentiality and to advise the sender
>immediately of any error in transmission.
>
>
>
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp



________________________________________________________________________
Scottish Enterprise Network
http://www.scottish-enterprise.com

Headquarters Address & Contact Numbers

150 Broomielaw
5 Atlantic Quay
Glasgow
G2 8LU.
Tel:  +44 (0) 141 248 2700.
Fax:  +44 (0)141 221 3217

 This message is sent in confidence for the addressee only.
It may contain legally privileged information. The contents are not to
be disclosed to anyone other than the addressee. Unauthorised recipients
are requested to preserve this confidentiality and to advise the sender
immediately of any error in transmission.