Front Page - Publishing objects from Excel

Author

Publishing objects from Excel

Thor

2005-01-29, 7:17 pm

Hello,
I update a table in Excel which i save as web-page and later publish on a
web-site. In FrontPage I added a web counter. Each time I update the table in
Excel I have to add the counter in FP again. How can I keep added HTML-code
for the counter?

In the HTML-script it says "If the same element is published again from
Excel, all information between the DIV-parameters will be replaced".

Even if my code for the counter is outside the DIV-parameters it is
overwritten.
How can I get around this?

Thomas A. Rowe

2005-01-29, 11:18 pm

Because the page is being replaced each time you generate it from Excel. The counter is a function
of FP, so it must be re-added to the page via FP. You could look into creating your based page in FP
with the counter, then along as you always name the page generated fro Excel the same, use the FP
Include Page component to insert it into your page with the counter.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Thor" <Thor@discussions.microsoft.com> wrote in message
news:395BDE30-6D94-4532-B45D-22365EE735EC@microsoft.com...
> Hello,
> I update a table in Excel which i save as web-page and later publish on a
> web-site. In FrontPage I added a web counter. Each time I update the table in
> Excel I have to add the counter in FP again. How can I keep added HTML-code
> for the counter?
>
> In the HTML-script it says "If the same element is published again from
> Excel, all information between the DIV-parameters will be replaced".
>
> Even if my code for the counter is outside the DIV-parameters it is
> overwritten.
> How can I get around this?

Andrew Murray

2005-01-30, 4:14 am

Save the Excel file as you've been doing

Then in Frontpage, create another html (new page) file. Insert the above as
an include page.

So you can now update the excel file, export as html to the filename
exceldata.htm, which is an include page in data.htm, and the counter stays
where it is, as the page is not being overwritten each time you saved the
new data from the excel spreadsheet.

Publish both files through http mode in Frontpage. View the page through
your browser, and make sure it all works to your satisfaction.

I hope this helps, and makes sense.

"Thor" <Thor@discussions.microsoft.com> wrote in message
news:395BDE30-6D94-4532-B45D-22365EE735EC@microsoft.com...
> Hello,
> I update a table in Excel which i save as web-page and later publish on a
> web-site. In FrontPage I added a web counter. Each time I update the table
> in
> Excel I have to add the counter in FP again. How can I keep added
> HTML-code
> for the counter?
>
> In the HTML-script it says "If the same element is published again from
> Excel, all information between the DIV-parameters will be replaced".
>
> Even if my code for the counter is outside the DIV-parameters it is
> overwritten.
> How can I get around this?