?
Solved

batch insert

Posted on 2004-09-27
9
Medium Priority
?
229 Views
Last Modified: 2013-12-24
At the bottom of of a "batch" of web files (*.html)  in fp 2003 i want to insert the following html.

Any suggestion on how to do this. FP VBA answer would be preferred.

<TABLE cellSpacing=0 cellPadding=0 width=660 border=0>
        <TBODY>
        <TR bgColor=#99CCFF>
          <TD>&nbsp;</TD></TR>
        <TR>
          <TD>
            <TABLE>
              <TBODY>
              <TR>
                <TD align=left><FONT face="Arial, Helvetica, sans-serif"
                  size=2>Assessor Data 03/2002</FONT><BR></TD></TR>
              <TR>
                <TD align=left><FONT face="Arial, Helvetica, sans-serif"
                  size=2>Deed Information Also Available:&nbsp; <A
                  href="http://www.real-properties.info/">http://www.real-properties.info/</A>&nbsp;
                  586-264-1095&nbsp;&nbsp;
        </FONT></TD></TR></TBODY></TABLE></TD>


Cordially Brian Powell.
0
Comment
Question by:brianpowell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
9 Comments
 
LVL 14

Accepted Solution

by:
hhammash earned 1000 total points
ID: 12166418
Hi,

You have two ways in HTML:

1- Using Shared Borders (Fastest way in FP)
- Open the Web
- Select Format > Shared Borders
- Click next to All Page
- Don't Select Top, left or Bottom yet
- Click OK
- Tools>Web Settings>Advanced to and show hidden files and folders
- Create a new webpage,  put the table in it and save it as bottom.htm inside the _borders folder.
- Opent Format>Shared Borders and click next to Bottom

Now you will have the table at the bottom of each page.


2- Using ASP or PHP
- Create a page with the table above and save it as table.htm
- Go to each page and include it using ASP or PHP

I don't know how to do a macro in VBA to do that.

Regards
hhammash
0
 
LVL 14

Expert Comment

by:hhammash
ID: 12166430
Hi,
When you go Format>Shared Borders and click bottom check box,  make sure that All Pages option button is also selected.
0
 
LVL 12

Assisted Solution

by:rcmb
rcmb earned 1000 total points
ID: 12239655
Select the pages you desire to the view folders window.

Make sure selected files is selected and check the box for find in source code.

Click on edit, replace and in the find what enter </body>

in the replace window enter:

<TABLE cellSpacing=0 cellPadding=0 width=660 border=0>
        <TBODY>
        <TR bgColor=#99CCFF>
          <TD>&nbsp;</TD></TR>
        <TR>
          <TD>
            <TABLE>
              <TBODY>
              <TR>
                <TD align=left><FONT face="Arial, Helvetica, sans-serif"
                  size=2>Assessor Data 03/2002</FONT><BR></TD></TR>
              <TR>
                <TD align=left><FONT face="Arial, Helvetica, sans-serif"
                  size=2>Deed Information Also Available:&nbsp; <A
                  href="http://www.real-properties.info/">http://www.real-properties.info/</A>&nbsp;
                  586-264-1095&nbsp;&nbsp;
        </FONT></TD></TR></TBODY></TABLE></TD>
</body>

This will replace every instance of </body> with the code above and reinsert the </body> tag at the end.

RCMB
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 12

Expert Comment

by:rcmb
ID: 12374943
Did this work for you? Have you abandoned this question?

RCMB
0
 
LVL 14

Expert Comment

by:hhammash
ID: 12671487
No ojbection
0
 
LVL 1

Author Comment

by:brianpowell
ID: 12674880
splitting the points will be ok.  SORRY for abandoning this topic not sure what happened here.

I did change jobs and such.

Thank you all for your  input.

brian powell
0
 
LVL 12

Expert Comment

by:rcmb
ID: 12674912
No objection
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question