Solved

batch insert

Posted on 2004-09-27
9
227 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 250 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 250 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

733 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