Trying to get my questions answered again...updating charts in a w

[Guest]

I have a website: www.applestats.com

It was created with MS Frontpage 2003 and it is published to the web using
HTTP

I have numerous charts on it, created from Excel

I update the charts every 2 weeks by going onto the appropriate worksheet
which is not located on the website, updating the chart that I keep on the
worksheet and copying the chart, pasting it to the FP2003 file and
re-publishing it.

I think there has to be a shortcut in there somewhere...

How would I get a little more automation to the updating?

Keep the worksheets in a website folder?

Is there a way to get the chart that is on the website to be conected to the
worksheet, so that when I update the worksheet, the chart on the web gets
updated?

I am trying to eliminate copying pasting the chart.

Thanks to all who respond.

 

[Thomas A. Rowe]

Not possible to automate unless you are hosting the site on your own internal server.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

Yes, we do host the site on our own server...

Not possible to automate unless you are hosting the site on your own internal server.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Thomas A. Rowe]

Then you need to set up a folder that is shared on the web, then store your excel file(s) in this
folder, then create link to the Excel Worksheets and Charts. All users will need to have Excel.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

ok...making the shared folder is easy enough...putting the excel files in..no
prob...

All the viewers of the website will need excel?

 

[Thomas A. Rowe]

Yes, because they will be accessing the Excel files directly. If you export/create HTML files then
you break any connection with Excel, so you would then continue to have to do what you are currently
doing. You may be able to write a VBA to automate the process, for this post to the Excel newsgroup,
as it is not a FP related issue.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Guest]

Thanks for the info....."VBA"?

Yes, because they will be accessing the Excel files directly. If you export/create HTML files then
you break any connection with Excel, so you would then continue to have to do what you are currently
doing. You may be able to write a VBA to automate the process, for this post to the Excel newsgroup,
as it is not a FP related issue.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Thomas A. Rowe]

VBA = Visual Basic for Applications

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================