ajwnet
asked on
Open Excel file in Excel from HTM based hyperlink?
Running NT4 server (but not HTTP service) with W95 clients, local intranet, navigated with HTML menu pages. Hyperlinks will launch Excel files in browser window (IE4+), but some Excel functionality is lost.
Anyone know how I can use a hyperlink to force an XLS file to open inside Excel? HTML pages and Excel files are all located on the same NT server. HTML/Java/VB/ActiveX suggestions welcome.. Need more info let me know.
Anyone know how I can use a hyperlink to force an XLS file to open inside Excel? HTML pages and Excel files are all located on the same NT server. HTML/Java/VB/ActiveX suggestions welcome.. Need more info let me know.
Change the mime types in the browser.
ajwnet,
This behaviour is kind of annoying, but I have found one work-around that may be ok for you.
1. Create a shortcut to the excel file.
2. Let the HTML page refer to the shortcut (filename.lnk) instead of the Excel workbook file directly.
When the user clicks the link, he will be asked if he wants to run the application. The workbook will open in Excel if he says yes.
Ture Magnusson
Karlstad, Sweden
This behaviour is kind of annoying, but I have found one work-around that may be ok for you.
1. Create a shortcut to the excel file.
2. Let the HTML page refer to the shortcut (filename.lnk) instead of the Excel workbook file directly.
When the user clicks the link, he will be asked if he wants to run the application. The workbook will open in Excel if he says yes.
Ture Magnusson
Karlstad, Sweden
ASKER
Sorry Seron, but needs to be a server/source based fix - don't like the idea of modifying the 25,000 client machines who have access to our company network.
As you say, Ture, it's a good workaround, if only it didn't require a confirmation..
Anyone else got an idea? I'd hoped there'd be a way of launching Excel using VB script... perhaps using shell?
As you say, Ture, it's a good workaround, if only it didn't require a confirmation..
Anyone else got an idea? I'd hoped there'd be a way of launching Excel using VB script... perhaps using shell?
None other than posing the question in the other relevant E-E sections too. Whether you try it with 0 point questions referering to this one or separate ones is up to you and your point/cash account.
\cri
\cri
I answered similar question:
https://www.experts-exchange.com/jsp/qShow.jsp?ta=browsers&qid=10165254
Is it OK for you?
Open "My Computer" and go to menu View-Options-FileTypes.
Find the desired file type (for example, Microsoft Excel Worksheet), select it and click Edit...
Uncheck "Open web documents in place" and confirm your changes pressing OK.
https://www.experts-exchange.com/jsp/qShow.jsp?ta=browsers&qid=10165254
Is it OK for you?
Open "My Computer" and go to menu View-Options-FileTypes.
Find the desired file type (for example, Microsoft Excel Worksheet), select it and click Edit...
Uncheck "Open web documents in place" and confirm your changes pressing OK.
ASKER
Thanks yuk, best fixes are the simple ones. Discovered this early on - would be great if it didn't mean a configuration change on all 25,000 client machines. Been looking for a button/registry patch that can be made available on our intranet to provide one-click switch on/off in-browser activation for users. Still think there must be a java/vb solution somewhere out there that has no nags..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh, I forgot to mention it is for Excel 97. Do you need the fix for another version? The registry key should be close to the above one. Just uncheck the flag and search for BrowserFlags value in registry. It seems all classes have this flag checked by default.