This works for me:
Sub ReplaceHTML()
'Replace html of a .htm-file in FrontPage
'by html saved in a .txt-file
'for Word:
Dim MyPath As String
Dim myDoc As String
'for the following instructions activate Tools, References, Frontpage
'for frontpage:
Dim...
Hi,
For a vba Excel macro I try to find the code to select the content of a html-page in FrontPage (in order to replace it with the content of the clipboard). The explanations on the website of MS are not clear enough for me. An example would be great.
The Excel-macro opens a txt-file in Word...
Hi PHV,
Thank you for your reaction.
WrdApp.Documents.Close False
This is the code I initially used, but it did not close all documents. I now think the reason for this must have been that while testing and restarting my program each time, several instances of Word were opened. Apparently...
Hi,
From vba Excel I would like to open Frontpage and display a webpage. I tried following, but that does not work:
Set FPApp = CreateObject("FrontPage.Application")
FPApp.Visible = True
FPApp.WindowState = fpWindowStateNormal
FPApp.Resize Width:=300, Height:=350
Set FPDoc =...
Hi,
I solved the problem by putting in place a bookkeeping of all txt files that are opened and close them one by one with a routine at the end of the program.
WrdApp.Windows(MyFile).Activate
WrdApp.ActiveDocument.Close False
Thanks for trying to help.
@PHV: Sorry for the delay in replying. Spent my day waiting for a plane that did not come. Storm.
@Phantek: I wrote this path as an example for the forum and forgot the quotation mark. In reality I use a string variable for the path and file.
@PHV: The code I use to open Word and a text file...
Hi,
In my application VBA Excel opens .txt-files in Word. These are temporary files in a specific folder and when the program starts it must kill all existing .txt-files in the folder. When one of the .txt files is still open an error occurs. Is there a way to close all open .txt files in the...
Hi Skip,
My web editor is FrontPage. However, I want to use vba-Excel to apply the modifications to the html-code, as I can enumerate the different find and replace instructions more easily on an Excel sheet. (Also I have to compose a new specific html-section with vba-Excel.)
Meanwhile I...
Hi,
I need to make changes to 170 existing web pages (courtfool.info). All pages have the same structure (that is: a table dividing each page in parts and many divisions <div> for different purposes). The existing content would have to be transferred to a template with a different structure.
Can...
Hi,
I need to add new HTML-code to all my web pages. I made a query using the Find & Replace function in FrontPage and saved it as "Replacement.fpq".
Now I am looking for the vba-code to call the query from a FrontPage-macro. Does anyone know this code?
Thank you very much in advance.
Hi MakeItSo,
I presume most people care about their own ranking, but this list is intended to thank people for publishing my articles, thus to improve their ranking. Normally, these are not cross-linkings.
I am sorry, but I don't understand what you mean by filling the sitemap with the links...
Hi MakeItSo,
I know I can add the snippet with the list to the sitemap. And of course, Google robots will find it. The question is, how do the robots consider it? When the list is on each page, I suppose that the links are considered having to do with the subject of the page. I presume that...
The redirect turns out to be very simple:
<META HTTP-EQUIV="Refresh"
CONTENT="1; URL=test_page.shtml">
Unfortunately ranking issue look more problematic. The instructions for the best Google ranking say that robots must be able to crawl each page easily...
Would I need a macro afterall...
Hi MakeItSo,
It works! However, the calling page must apparently be renamed from .htm to .shtml (and not .shtm) :-)
In my website there are several hundreds of internal links, but FrontPage adapts them automatically when renaming pages, so that should not cause any problems.
Redirect?
At...
Hi MakeItSo,
I have renamed http://www.courtfool.info/zz_ontwerp2.htm as
http://www.courtfool.info/zz_ontwerp2.shtm
In my firefox browser it now shows the code of this calling page.
Tonight (Paris time) I will have a look in the other forum you mentioned to see if I can make this method...
Hi MakeItSo,
Thank you very, very much for your help. If I get this to work it will save me many hours of editing.
However, I apologize, but I must have misunderstood your explanation. I have uploaded a testpage
http://www.courtfool.info/zz_ontwerp2.htm
which includes the code you proposed...
Hi,
I edit my webpages ( www.courtfool.info ) with FrontPage. A list with names is repeated on each page. Each time an element is added I must change the list on over 100 pages. I try to make a macro that would copy the new list from the index page to all others, but I cannot find the correct...
Hi Vacunita,
Great!!! The second method with the comment form works!!!
I won't tell you how much time I have spent searching for a solution ;-)
As for the division 'comment' solution, that did not work here. I don't know if it is because of my Firefox browser or something else, but I will still...
Hi,
Could someone help me with following?
In one frame, I have a list with hyperlinks (code below) and when you click on a link a picture appears in another frame (main2). So far so good. At each hyperlink I would like to add a short comment to be displayed in a separate frame (country_name)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.