|
|
you just have to put your cursor on the cell you want to open and save your excel sheet then. When you open your excel sheet again, the cursor is on that cell....
|
|
|
|
to do what you want you have to delete the .xls file and have only the .htm file. Work on the .htm file only; use the edit with microsoft office excel icon that is in the menu bar of your IE6 or 7 browser. You are in excel with all is functions and you can work it. When you save, it saves as .htm file. Rmember that an excel XX.htm files has a xx_files folder where all the sheets and graphs are stored.
|
|
|
|
to do what you want you have to delete the .xls file and have only the .htm file. Work on the .htm file only; use the edit with microsoft office excel icon that is in the menu bar of your IE6 or 7 browser. You are in excel with all is functions and you can work it. When you save, it saves as .htm file. Rmember that an excel XX.htm files has a xx_files folder where all the sheets and graphs are stored.
|
|
|
|
Hi,
I would like to know how I can host an excel file on a server that would allow a user to access , view and modify/add some content to the file via the internet without downloading the file itself. Each user will access a copy of this file that they will be able to use and save any changes, under their own name, they may have made back to the server for future use. The user should not have the option to download the file, save it on their computer or be able to view or change certain cells, columns, rows or view the VBA code behind it. The user will access the file via a website using a provided login and password. While the file is open and in use by the user, some cells will be updated in real time drawing on information and values from 3rd party software (DDE links).
While the overall structure seems to be fairly straightforward – a server, a website and excel. It becomes murky when I try to work out the details in how exactly to connect the three. I understand that ActiveX plug-in maybe needed in order to allow the user to open the excel file in IE but I have a feeling there maybe something more to it than just that.
I would like to know your opinion and view on the best approach to achieve this task.
regards,
Sonia
|
|
|
|
<a href="data/myFile.xls" target="_blank" >.....
|
|
|
|
Thank you all..this way of opening the excel file worked for..but now what i want to do is get the data from MySQL into this excel file. How to do that using queries?
|
|
|
|
Hi,
I am also trying the same thing to connect with an excel sheet using HTML command.
I even tried the guideline you have given,but was not able to connect.
My code:
<A HREF="C:\Manisha's Doc\MO_status.xls" target="_blank">CONTACT</A>
<A HREF="C:\Manisha's Doc\MO_status.xls">TEAM CONTACT</A>
<A HREF="C:\Manisha's Doc\MO_status.xls#Sheet1!A1">PARTNERS CONTACT</A>
I have used three ways to connect with aqn excel sheet.
Could you please guide me how to proceed.
|
|
|
|
Hi Tory,
If this mail reaches you, please respond. I am looking for HTML code.
The requiremnent is to open Excel application from a link in a html page.
(the excel should open outside the Browser)
Your help will be highly appreciated.
Please reply to me on paddy4sap@gmail.com
Regards
Paddy
|
|
|
|
Thanks for you reply, I meet the same problem.
|
|
|
|
Thanks for you reply, I meet the same problem.
|
|
| This 40 message thread spans 3 pages: < < 1 2 [3] > > |
pratclif
