|
 |
asp_web_howto thread: opening an excel document outside the browser
Message #1 by "Nick" <nick@f...> on Wed, 30 Jan 2002 14:27:17
|
|
Hi,
I have an intranet application that has links to various company documents
in Excel format. When a user clicks on the link it opens a new browser
window and the excel document appears within the browser window.
Is there any way in which I can get the link to launch Excel and open the
document in Excel rather than opening it within the browser.
I would also like to be able to do the same thing with Word documents.
Thanks,
Nick
Message #2 by "phil griffiths" <pgtips@m...> on Wed, 30 Jan 2002 16:31:20
|
|
This is a windows explorer setting. Choose View|Folder Options and in the
dialog that comes up choose the File Types tab, scroll down to Microsoft
Excel Worksheet and click the Edit button which brings up another dialog.
In this dialog there's an option called 'browse in same window'. Uncheck
this option and it will open in Excel not the browser.
This is what it's like on my machine, NT4, SP6a, Option Pack. Hope its
the same on yours.
It'll be pretty tedious to change for all of your users...
HTH
Phil
> Hi,
>
> I have an intranet application that has links to various company
documents
> in Excel format. When a user clicks on the link it opens a new browser
> window and the excel document appears within the browser window.
>
> Is there any way in which I can get the link to launch Excel and open
the
> document in Excel rather than opening it within the browser.
>
> I would also like to be able to do the same thing with Word documents.
>
> Thanks,
>
> Nick
Message #3 by Nick Charlesworth <nick@f...> on Wed, 30 Jan 2002 16:49:17 -0000
|
|
Is there a way to do it with client side VB script?
-----Original Message-----
From: phil griffiths [mailto:pgtips@m...]
Sent: 30 January 2002 16:31
To: ASP Web HowTo
Subject: [asp_web_howto] Re: opening an excel document outside the
browser
This is a windows explorer setting. Choose View|Folder Options and in the
dialog that comes up choose the File Types tab, scroll down to Microsoft
Excel Worksheet and click the Edit button which brings up another dialog.
In this dialog there's an option called 'browse in same window'. Uncheck
this option and it will open in Excel not the browser.
This is what it's like on my machine, NT4, SP6a, Option Pack. Hope its
the same on yours.
It'll be pretty tedious to change for all of your users...
HTH
Phil
> Hi,
>
> I have an intranet application that has links to various company
documents
> in Excel format. When a user clicks on the link it opens a new browser
> window and the excel document appears within the browser window.
>
> Is there any way in which I can get the link to launch Excel and open
the
> document in Excel rather than opening it within the browser.
>
> I would also like to be able to do the same thing with Word documents.
>
> Thanks,
>
> Nick
$subst('Email.Unsub').
Message #4 by "phil griffiths" <pgtips@m...> on Thu, 31 Jan 2002 09:45:57
|
|
It seems to be just a reg setting. This works for me:
Dim oShell
Set oShell = WScript.CreateObject("WScript.Shell")
oShell.RegWrite "HKCR\Excel.Sheet.8\BrowserFlags", 8, "REG_DWORD"
Set oShell = Nothing
maybe you'll have to nose around the registry to find the exact key for
the version of excel that you have, I have 97. Or you could run regmon
(www.sysinternals.com), go to explorer and change the setting and see what
new key has been written.
HTH
Phil
> Is there a way to do it with client side VB script?
>
> -----Original Message-----
> From: phil griffiths [mailto:pgtips@m...]
> Sent: 30 January 2002 16:31
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: opening an excel document outside the
> browser
>
>
> This is a windows explorer setting. Choose View|Folder Options and in
the
> dialog that comes up choose the File Types tab, scroll down to Microsoft
> Excel Worksheet and click the Edit button which brings up another
dialog.
> In this dialog there's an option called 'browse in same window'.
Uncheck
> this option and it will open in Excel not the browser.
>
> This is what it's like on my machine, NT4, SP6a, Option Pack. Hope its
> the same on yours.
>
> It'll be pretty tedious to change for all of your users...
>
> HTH
> Phil
> > Hi,
> >
> > I have an intranet application that has links to various company
> documents
> > in Excel format. When a user clicks on the link it opens a new browser
> > window and the excel document appears within the browser window.
> >
> > Is there any way in which I can get the link to launch Excel and open
> the
> > document in Excel rather than opening it within the browser.
> >
> > I would also like to be able to do the same thing with Word documents.
> >
> > Thanks,
> >
> > Nick
> $subst('Email.Unsub').
|
|
|
View Cart
