• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

batch insert

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
brianpowell
Asked:
brianpowell
  • 3
  • 3
2 Solutions
 
hhammashCommented:
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
 
hhammashCommented:
Hi,
When you go Format>Shared Borders and click bottom check box,  make sure that All Pages option button is also selected.
0
 
rcmbCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
rcmbCommented:
Did this work for you? Have you abandoned this question?

RCMB
0
 
hhammashCommented:
No ojbection
0
 
brianpowellAuthor Commented:
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
 
rcmbCommented:
No objection
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now