Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rudo
  • Order by date
  1. rudo

    vba-Excel: Select content of HTML-page in FrontPage?

    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...
  2. rudo

    vba-Excel: Select content of HTML-page in FrontPage?

    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...
  3. rudo

    Open Frontpage to display webpage with VBA Excel

    Hi PHV, Thank you for the suggestion. You are better than Google ;-) Greetings, Rudo
  4. rudo

    VBA Excel with Word, close all txt files in folder?

    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...
  5. rudo

    Open Frontpage to display webpage with VBA Excel

    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 =...
  6. rudo

    VBA Excel with Word, close all txt files in folder?

    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.
  7. rudo

    VBA Excel with Word, close all txt files in folder?

    @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...
  8. rudo

    VBA Excel with Word, close all txt files in folder?

    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...
  9. rudo

    Copy content of existing webpages to new template?

    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...
  10. rudo

    Copy content of existing webpages to new template?

    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...
  11. rudo

    Call a query from Frontpage-macro?

    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.
  12. rudo

    Copy and paste a selection to all web pages?

    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...
  13. rudo

    Copy and paste a selection to all web pages?

    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...
  14. rudo

    Copy and paste a selection to all web pages?

    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...
  15. rudo

    Copy and paste a selection to all web pages?

    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...
  16. rudo

    Copy and paste a selection to all web pages?

    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...
  17. rudo

    Copy and paste a selection to all web pages?

    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...
  18. rudo

    Copy and paste a selection to all web pages?

    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...
  19. rudo

    Hyperlink to display pics and comments in parent frames?

    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...
  20. rudo

    Hyperlink to display pics and comments in parent frames?

    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)...

Part and Inventory Search

Back
Top