Hi
Is it possible to make an excel spreadsheet avaible online on a homepage, so the users can use the spreasheet on the page(not by downloading it)?
And at the same time hide the vba-code, so the user can't see it?
If it is possible how do I do it/where can I find some more information on this topic?
Regards
Troels Isaksen
You can do this with File Transfer Protocol (FTP) have a look here http://puremis.net/excel/code/082.shtml
and here http://support.microsoft.com/kb/237828#top
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
You'll also need access to an FTP site to host your files - this one's free (there may be others)
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
thanks but that's not exactly what I'm looking for.
The users should be able to use the worksheet on the site without having to download. And second the users are not allowed to edit or viewing the vba code.
Sort of like this site: http://www.editgrid.com/user/thomas_...VoIP_Prisguide
Just with a standard excel worksheet and a vba code.
Any suggestions?
Regards
Troels
Why don't you use Google's spreadsheet? Unless you want to put one on your site.
???Originally Posted by troelsi
FTP allows users to use anothers workbook on a site without having to download, but to do this they must set the workbook to 'shared' and you can't view or edit VBA code in shared workbooks ???
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
Reply With Quote
