Solved

batch insert

Posted on 2004-09-27
9
226 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
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…

777 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