I have the following code to open a web page: Dim IE Set IE = CreateObject("internetexplorer .application") mySTR = "[link]" IE.Navigate mySTR The code works if I run it from vba - it opens the page on top of Word. But if I assign it to a QAT or Ribbon button, it opens the page but leaves it... Mehr »
I upgraded from Win-XP/Office 2003 to Win-7/Office 2007; the code below ran fine in Word 2003 but in Word 2007 generates runtime error 4198. The variables and directory location are valid. The parameters for FileName are updated for Word 2007; the grammer for the FileName appears correct (no grammer errors when macro runs as is, but grammer errors if I change the... Mehr »
Hi All, I have a macro that seeks out a particular string of text in a document and then moves down one line and selects the remaining text nin the document and writes it to a variable and then uses it subsequently in the message section of an email. Recently this method has been failing because the text is not being... Mehr »
I have a couple of userforms that I want to open by providing a custom toolbar. I guess I would do this by placing macros on the toolbar but can someone advise how I would reference the userforms within the macro? Thanks .. Dave
Hi everyone. I have hit a problem with a protected form I'm working with. I have a macro that allows users to add a new row to a table within the protected form, the macro adds formfields in to the new row, one of which is a calculation field. This calcuation field simply multiplies the previous two fields contents... Mehr »
Hi, I have a macro which finds a certain piece of text in the document and then moves down a line and then selects all the text between that and the end of the document and the selected text is later sent out in an email. This has been working for some time but I have recently had some problems because the... Mehr »
Hi, everyone. Got a question I'm hoping someone can help with. I have been given a form which is a Word Template and asked to add in functionality that would take the information entered in certain places and have it automatically duplicate in the header of each page. Apparently this was possible in winxp/office2003 but now in vista/office2007 these templates... Mehr »
I just tried a simple record macro and it did not record what I expected. I attempted to record a paste special unformatted text and it just recorded: Selection.PasteAndFormat (wdPasteDefault) This is not very close to what I did. Is there a way to get the macro recording to work like previous versions?... Mehr »
What is the maximum number of macros that can be used in a single word document. I have a Word document with a front page with 3 columns and multiple rows. In column 2 & 3 there is a different macro buttons that when clicked on will print a certain page in the document or go to a specific page in the document... Mehr »