FP2k3: How to update a website easly from a Excel Sheet.

[Eric C. Vogel]

Anyway to do this easily for someone who is not very computer literate?

Also I do not know how to do set it up, if it can be done with FP 2003 (This
part does not have to be super easy, I know how to use FP, but I know little
HTML and not languages). But updating the website with Excel has to be easy
for the person I am designing it for.

I will take other suggestions for free to low cost ways to achieve this if
Excel is not available.

I have not studded the sheet but it would be not very complete. He may have
it categorized view sheets, so it would be nice if each sheet was on a
different webpage.

Please note this is for a one man one pc in his house operation.

Thank you,
Eric

 

[Jim Buyens]

With some limitations and precautions, you can process
named ranges in Excel spreadhseets as if they were
database tables. In practice, however, this is
*extremely* error-prone. Most people who try it give up.

It's much better to use Access or some other database.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Stefan B Rusynko]

Or if the data is not changing that often,
Just Save the Excel file as a web page (all sheets) and File Import it into FP
See
http://www.microsoftfrontpage.com/content/ARTICLES/SavetoWeb.htm
or
http://support.microsoft.com/default.aspx?scid=268948

Other approaches w/ Excel would be to write some VBA code to programmaticly extract the Excel ranges and open FP / publish
- but that would also require a knowledge of VBA and the Excel/FP Object modules




| With some limitations and precautions, you can process
| named ranges in Excel spreadhseets as if they were
| database tables. In practice, however, this is
| *extremely* error-prone. Most people who try it give up.
|
| It's much better to use Access or some other database.
|
| Jim Buyens
| Microsoft FrontPage MVP
| http://www.interlacken.com
| Author of:
| *----------------------------------------------------
| |\---------------------------------------------------
| || Microsoft Office FrontPage 2003 Inside Out
| || Microsoft FrontPage Version 2002 Inside Out
| || Web Database Development Step by Step .NET Edition
| || Troubleshooting Microsoft FrontPage 2002
| || Faster Smarter Beginning Programming
| || (All from Microsoft Press)
| |/---------------------------------------------------
| *----------------------------------------------------
|
|
|
|
| >-----Original Message-----
| >Anyway to do this easily for someone who is not very
| computer literate?
| >
| >Also I do not know how to do set it up, if it can be
| done with FP 2003 (This
| >part does not have to be super easy, I know how to use
| FP, but I know little
| >HTML and not languages). But updating the website with
| Excel has to be easy
| >for the person I am designing it for.
| >
| >I will take other suggestions for free to low cost ways
| to achieve this if
| >Excel is not available.
| >
| >I have not studded the sheet but it would be not very
| complete. He may have
| >it categorized view sheets, so it would be nice if each
| sheet was on a
| >different webpage.
| >
| >Please note this is for a one man one pc in his house
| operation.
| >
| >Thank you,
| >Eric
| >
| >
| >.
| >

 

[Eric C. Vogel]

Thank you Jim and Stefan. I will see about Access. Since he can put it sheet
into a table, it should not be that hard for him to do.. I will be meeting
with him on Tues or Thurs and go from there. I hope he likes the way Front
Page Templates look like..
I could not find a suitable them at ThemePack. I would guess something with
a theater look, but the ones on TP are too dark. Maybe a general sports
theme. The movie theme was nice, just too dark and minus the popcorn.