|
|
i want to open an existing excel file on click of the link. the condition is.. i want excel to be opned when i click on link.. it should open in Excel application instead of Browser..
|
|
|
|
<a href="/forum/data/myFile.xls" target="_blank" >
|
|
|
|
|
Keith, a link like that will work, but on a Windows computer with a default IE and Excel install, the spreadsheet will open with Excel WITHIN the browser--rather than directly with Excel. I think this person is asking how to force the spreadsheet to open outside the browser. I don`t know of any way to bypass the user`s plug-in preferences, but perhaps there is a way to do this. I`m interested to see if someone has a method to accomplish this goal.
|
|
|
|
|
|
Hi Troy, You are right. I am looking for the solution to force open the file outside the browser in excel application. I did some R &D on that and found the work around. I had created the shortcut of that file, for example abc.xls.lnk, when created the hyperlink of shortcut instead of original excel file. When click of this link, it will open in excel application, outside the browser.
Not the very elegent solution, but works well !
|
|
|
|
|
Does the target of your shortcut include the full path to the Excel exe? Or is it just a shortcut to the .xls file? I`m curious. Thanks!
|
|
|
|
|
|
you just need to have the path of shortcut, the path of excel application needs not to mentioned.
<a href = "data/myfile.xls.lnk> click here </a>
when you create the shortcut in Windows Explorer, it will not display the file extension, the ext is .lnk
|
|
|
|
|
Right, but in your shortcut, what is the "target"? Does that target have the full path to the Excel executable? Or is it just a link to the .xls file? I ask, because I`m guessing that your .lnk is a shortcut to Excel passing in the .xls as a parameter. I`d think a .lnk to the file directly would just open the spreadsheet in the browser again. Let me know. Thanks!
|
|
|
|
|
|
Hi Troy,
I have a similar kind of requirement. I have not written much of HTML codes. Very Novice.
In brief I am writing a PL/SQL server page(psp), which has commands similar to html tags. My files (pdf.doc/txt/xls etc) are stored in Oracle databse. This PSP is written to implement Oracle text where in one can search files from database on the basis of provided search criteria. This works fine and my file opens when I cleck to its link. BUT.....
It opens in browser and not using its executable. Now as you say "Does that target have the full path to the Excel executable? " .Please let me know how do I specify the executable path in any html to open a file saved in database.
i.e how do I associate the respective executable to a file.
Regards,
|
|
|
|
It is possible to configure how to open documents with Microsoft Internet Explorer. Documents can be opened inside the browser itself or with the original application like MS Office or Acrobat Reader. Opening it with the integrated viewer does not provide the full functionality of the original application.
You can force the Internet Explorer to open the documents with the original application by changing the file type association in Windows Explorer (not Internet Explorer). To do this select menu "Extra / Folder Options" in Windows Explorer (where your files are listed), select the file type you want to change on the file types tap (esp. RTF and PDF), and disable option "Open in same Window" in the advanced settings.
|
|
|
|
|
Thanks for this excellent tip, Peter! I can use this myself. In an Intranet scenario where you have some level of control over the user computers, this would work. In a public Internet scenario, you would not have any control over how users configure their own computers. I guess he could post instructions on his site to explain to users how to make this change.
|
|
|
|
|
|
Hi,
I also have an HTML/Excel question as I am a bit of a coding novice so I hope you can help. I would like to open an Excel sheet, either in the Browser window, or separatly as an application, from a link from a web page. What I would specifically like to be able to do is make different links on the web page go to different areas of the sheet. For example the first link will open the sheet at Row 1, another link will open the sheet at Row 3500 etc. This is because I need to direct the user to different parts of very large sheets from different links on the page. This is better than opening the sheet at Row 1 each time and searching for what is required on the sheet. Is possible to go even further and open the sheet at a particular cell ie. the specified cell is the top left hand cell when the sheet opens? I am assuming that parameters need to be passed from HTML/Javascript to VBA Excel ? Is this correct? I hope someone can help me with this. Cheers in advance for your time.
|
|
|
|
I am having the same problem with opening a file outside of internet explorer. I'm trying to open a Microstation DGN file by clicking on a hyperlink. I tried going into the folder options and all, but it still tries to open the file in IE and IE does not support DGN files. Are there any suggestions on this?
|
|
|
|
|
I *think* you'll find success by linking to a properly configured shortcut (.lnk) instead of the file itself. Configure a shortcut to the application that passes the data file as a parameter. Then try setting your HTML link to the shortcut file. If this works, it will only work on Windows of course, and the user will have to have the app installed -- and in the same directory structure as the link specifies.
|
|
|
|
|
|
|
|
|
|
Hi Bramberg,
Thanks for the cool link. I went ahead and tested the VBScript on my computer, and it worked fine. The file opens directly into Excel. But I tested it on our server here at work and it didn't work. I surfed the net a bit for a solution and found out that you need to change a setting on the client computer to accept the Active X Script.
In browser go to Tools | Internet Options | Security | Custom Level.
By default Initalizing and Scripting ActiveX controls that are not marked safe is disabled.
Changed it from disabled to prompt, and the code works.
Another thing I'd like to mention about this thread is that with both of these solutions (VBScript, shortcut) you can now directly edit the Excel page to the server. This is not possible by opening up the Excel page in IE or unchecking the "Open in Same Window" checkbox in My Computer, because with these solutions a read only version is opened up.
Thanks for a most useful post. I'll keep this stuff in mind.
Peter
|
|
|
This 28 message thread spans 2 pages: [1] 2 > > |
Archive Import (Manoj Verma) 
Troy Wolf
arunima
