Web based SS

[MInConst]

I'm not sure if this is possible to do and reading what I have found so far makes me feel like it isn't but I have to ask anyway.
I have a very simple pricing spreadsheet that I would like to put online on my site for clients to use. Is it possible to place a usable spreadsheet on a webpage and allow visitors to us it and then have it reset when the user is done?
Thanks
Paul

 

[Logit]

.
Microsoft has a Cloud service for just that purpose. http://www.onedrive.com

 

[MInConst]

.
Microsoft has a Cloud service for just that purpose. http://www.onedrive.com

Thanks Logit,
Does one drive allow someone to edit the sheet and have it revert back to its original state when done?

 

[Logit]

.
One Drive is supposed to respond as though the spreadsheet/workbook were on your own computer. So anything that is done to it
by anyone, anywhere is as though you did it on your computer.

If you are wanting any change to be negated after someone "logs out", I believe the only way you can accomplish that would be to add a macro
that prevents saving changes. The following macro, placed in ThisWorkbook of your project will prevent saving any changes :

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)


    MsgBox "You can't save this workbook!"
    Cancel = True


End Sub

You will need to setup your workbook how you want it ... final presentation .. save that ... then insert the macro. Once the macro is in your workbook
you literally won't be able to save anything.

I am not all familiar with One Drive ... so can't say if it allows you to have a workbook that won't save changes, without the use of an added macro.

 

[MInConst]

.Thanks a lot Logit,
I will work on it and see if I can get this working. Sounds doable if One Drive is.
Appreciate the help.
Paul

 

[Logit]

.
You are welcome.

For future reference to assist others, once you get things going, report back on your progress so others can learn as well.

Cheers.

 

[MInConst]

Will do if I figure it out I'd be happy to share.