Links

J

Jayson

Hi , Is there a way to link specific Excel cells into a webpage. These cells needs to be updated on the spreadsheet daily , but must show as read - only in the webpage. Otherwise how do I show a spreadsheet in a webpage as read-only - the spreadsheet should however be edited in Excel . I am using FP 2002 & Excel 2000.
 
J

Jim Buyens

-----Original Message-----
Hi,
Howdy.

Is there a way to link specific Excel cells into a
webpage. These cells needs to be updated on the
spreadsheet daily , but must show as read - only in the
webpage. Otherwise how do I show a spreadsheet in a
webpage as read-only - the spreadsheet should however
be edited in Excel . I am using FP 2002 & Excel 2000.
Click to expand...

Yes and no.

FrontPage has no direct interface to Excel or any other
spreadsheets. The reason is that spreadsheets are desktop-
based, single-user applications, and the Web is server-
based and multi-user.

And if you want something that's server-based and multi-
user, you end up looking at databases. So the best
solution would be to convert your application to Access or
some other database system.

You can, however, treat a named range in Excel as if it
were a database table. The following articles may be
helpful in this regard but I must warn you, most people
who try this sort of thing eventually give up. Excel was
never designed for this type of application, and the
results are subject to many failures and limitations.

Microsoft Knowledge Base Article - 268948
HOW TO: Use an Excel Worksheet as a Data Source in
FrontPage 2000
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268948

Microsoft Knowledge Base Article - 195951
HOWTO: Query and Update Excel Data Using ADO From ASP
http://support.microsoft.com/default.aspx?scid=kb;en-
us;195951

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

Jayson

Hi Ji

Thank you very much - I think the best would be to then try & save the Excel spreadsheets in htm format on a daily basis. I there a way to mybe automate such a process ? We are starting an Intranet & the main focus for it is to have daily financial & production figures readily available. Ac most of our financial info is on Excel it would be diffcult to convert it , unless you create a new database in Access with just the nesessary detail.

Your comment would be appreciate

Regards
 
S

Stefan B Rusynko

You can use Excel VBA to automate the process and even access the FP web and use the FP VBA object model to "edit" pages (from
Excel) or publish a site
- I have a bank doing their daily interest rate updates using an Excel workbook "controlling" a page in a FP web

In Excel to access FP try

Dim objApp As FrontPage.Application
Set objApp = GetObject(, "FrontPage.Application")




| Hi Jim
|
| Thank you very much - I think the best would be to then try & save the Excel spreadsheets in htm format on a daily basis. I there
a way to mybe automate such a process ? We are starting an Intranet & the main focus for it is to have daily financial & production
figures readily available. Ac most of our financial info is on Excel it would be diffcult to convert it , unless you create a new
database in Access with just the nesessary detail.
|
| Your comment would be appreciated
|
| Regards
 
J

Jayson

Thks - not so sure what you mean by Dim objApp...etc , but I have connected Excel as a DB source to a Forms page in FP & then saving it as an *.asp page. The Excel spreadsheet can then be edited & saved .When you refresh the webpage it shows the new data. I just hope it will be fine like that

I have a few more problems
1. When trying to publish my web onto my PC or onto a server running IIS it gives an error that the *.asp pages are not supported , I've enabled asp pages in FP(2002) , but it just won't publish them correctly
2. How do I check if the FP extensions are installed & also correctly installed & how do you install them - Is it automatically installed when you install FP on a PC or is it manually ?
3.Also how do I deploy IIS & what version should I use for FP200

Thk
cheer
 
T

Thomas A. Rowe

1. Excel create/uses a single user file format, whereas you need to use Access which create/uses a
multi-user file format.

2. The FP extensions have nothing to do with being able to run ASP.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Jayson said:
Thks - not so sure what you mean by Dim objApp...etc , but I have connected Excel as a DB source
Click to expand...
to a Forms page in FP & then saving it as an *.asp page. The Excel spreadsheet can then be edited &
saved .When you refresh the webpage it shows the new data. I just hope it will be fine like that.
I have a few more problems
1. When trying to publish my web onto my PC or onto a server running IIS it gives an error that
Click to expand...
the *.asp pages are not supported , I've enabled asp pages in FP(2002) , but it just won't publish
them correctly.
2. How do I check if the FP extensions are installed & also correctly installed & how do you
Click to expand...
install them - Is it automatically installed when you install FP on a PC or is it manually ??
 
T

Thomas A. Rowe

Without the original message, most of us have no clue what you are talking about or asking!

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
S

Steve Easton

FrontPage extensions are not "part" of FrontPage.

They are installed with IIS, which is installed from your Windows 2000 Pro or XP pro install disk
using Add/Remove Programs > Add Windows Components.


--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
J

Jayson

Apologies , I am quite new to discussion goups , but are learning very quickly. Thank you ,for the feedback & I will install it soonest .

Cheer

----- Steve Easton wrote: ----

FrontPage extensions are not "part" of FrontPage

They are installed with IIS, which is installed from your Windows 2000 Pro or XP pro install dis
using Add/Remove Programs > Add Windows Components


-
Steve Easto
Microsoft MVP FrontPag
95isaliv
This site is best viewed...........
........................with a compute
 
Top