Shared Excel document

[808s]

How can i make an Excel document shared with the web server?

I have a webserver on the intranet, and i want the file to be accessable to few users, so they can fill the fields in the document.

I put the file on the server, it opens ok, you can fill in want you want, but then when you try to save it, it trys to save it to a local disk, and i want it to be saved to the webserver.

Help, please.-

[senshi]

Directly you cant.

However, you can use server-side & client-side programming to allow people to interact with or make and amment excel spreadsheet.

ActiveX,javascript and VBscript would be needed to complete the task.

VBscriipt to open and read as well as controling the placement of data into set fields.

ActiveX to aid the access of resources on your and the users machine and javascript to help your development.

[808s]

Is there any scripts that allow you to do that? php,cgi etc.?

I'm not so good at coding, so i would need a complete script

[senshi]

hmmm... how longs a piece of rope?

Its one of those things, you will have to learn some coding, no two ways about it, picking up scripting is pretty easy if you have ever developed programs before like during computer studies or what ever your computer sciences were called.

This is the point where you wish you had sat up and listened and not pissed about in class, but anyway, to start with, www.htmlgoodies.com will do you the world of good and you never know, by this time next week you could be slapping code together.

No one taught me but myself, you have the internet, that much is evident so use it, its a resource and tool for your advancement and education, thats how IM using it. It is an often over looked resource and even less understood.

I suggest the following path...

Learn HTML basics
add simple javascript
dabble with Active X controls and server-side scripting.

theirs lots of info out on the net, its just getting through it.

[808s]

I know HTML coding ez
Javasript, i can use but not write.
Cgi, , i can write a bit.
Php, i can use but not write.

Is there more instructions? i would need help with the actual excel document saving

[senshi]

no, just start scripting, you will soon see that other languages have a similar structure.

Javascript is useful as it not only can output HTML but also Javascript too as well as being able to run javascripts within a javascript thats external to the native code, eg, a text string passed into the eval() function will cause javascriopt to run that code or evaluate the string as if it was part of the existing script.

I have written a javascript loader that loads up other javascript modules that write a web page within the current document and other weird stuff like that, but I like to experiment with things and see just what they can do.

One las t point of reference, www.msdn.com littered with activX examples and how to use them, note that you are better off stickig to javascript and only using VBscript where no javascript alternative exists, thats because javascript can pass values to VBscript but I dont think VBscript can pass values back, dont quote me on that one.

You really need to sit down an look at what your trying to achieve, planning is important, the least thought of aspect of any development is forward planning, what do you need, what re the projects goals, who is my audiance, what services do I need and of course, Architecture, is your machine capable of handeling allot of processing?

If your really stuck, weekend college or community colleges or even some schools will runn nigth or evening classes where you can learn more about what you want to do.

[808s]

You really would have thought that someone had written such script/program, cause i see the need for this kind of thing.

I don't have the time to start studying etc., maybe someone will do it someday, hopefully soon.