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

  • Thread starter Thread starter Eric C. Vogel
  • Start date Start date
E

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
 
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)
|/---------------------------------------------------
*----------------------------------------------------
 
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
| >
| >
| >.
| >
 
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.
 
Back
Top