webpage/excel???

[Stu]

What I want to do is put an excel file on a webpage that is password
protected, but only on the webpage, and no password on the file when opened
by the user on the computer directly through the computer. is this possible?

 

[Kevin Spencer]

Hi Stu,

What you're describing is not a requirement, but a partial solution. A
requirement is described in business terms. For example, your requirement
might be that you have information in Excel spreadsheets that you want to
display in a web site. Or it might be that you have Excel Spreadsheets that
you want users to be able to open and edit on your web site. Or it might be
that you have some data that you want to make available on your web site.
The first step to designing a solid solution is to have your requirements
spelled out well.

Now, it might seem picky of me to say all that, but there is a method to my
madness. For example, you didn't specify whether or not you want this
spreadsheet to be "read only" to your visitors. If it is meant to be edited,
putting an Excel spreadsheet onto a web page is going to be a real challenge
to an experienced programmer. On the other hand, if it is not supposed to be
edited, there are a number of much simpler solutions. However, embedding an
Excel spreadsheet in a web page isn't easy, and you may not even need to do
that, if, for example, your only requirement is that the data in it be made
available on your web.

So, what are your business requirements?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Stu]

Hello Kevin,

I want the spreadsheet to be viewable and editable if possible, but the
minimum needs to be a read only version of a spreadsheet. the spreadsheet is
regularly updated (once or twice a week).

And you don't seem picky at all, I see the method to your madness.

 

[Kevin Spencer]

The simplest way to make a read-only copy of an Excel spreadsheet available
is to upload it to your web site and create a hyperlink to it. However, you
can also use the FrontPage database tools to create a web page that displays
the contents of an Excel Spreadsheet viewable as an HTML document. And if
necessary, you can use FrontPage database tools to create a web page that
allows users to make changes (in most cases). An Excel spreadsheet is a form
of database, and it can be connected to as such. On the other hand, it
wasn't designed as a database, and it can be difficult to do so.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.