Copying a table format in FrontPage 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my website I post the points results and positions of a junior motocross
club throughout the year.
I receive the info ie names, points, totals and positions in an Excel table;
I then run a macro in Excel then copy and paste the result into FrontPage.
Once in FrontPage I then have to alter text type and size, background and
column colours, column width, table % etc. I do this for 6 groups each time
and with updates throughout the year.
I would like to be able to copy the existing FrontPage table format rather
than go through the process every time there's an update. Is this possible
please?
Once on the website the table is 'fixed' ie it no longer needs to work as a
spreadsheet. Examples of the end product can be seen at www.ekssc.co.uk >
Championship Points.
Sorry for such a long question but I've tried to be explicit. Thanks Very
Much.
 
Personally, I would implement this as a Web database application. That is, I
would develop a HTML form that the referees (or coaches, or whoever) would
use to post scores and/or statistics, and then I would develop reporting
pages that calculated and displayed standings. Of course, that would require
a bit of ASP.NET or ASP programming.

Otherwise, I'd suggest either:

o Copying from Excel, pasting into Notrepad,
copying from Notepad, and then pasting into FrontPage, or

o Copying from Excel, pasting into FrontPage, opening the Paste Options
menu (the little dohickey that appears near the lower right corner of the
pasted content) and then choosing Keep Text Only.

This will leave you with some formatting to do, but at least you won't have
to undo the Excel formatting.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------
 
Back
Top