Run-time error '5991' Dave, Thanks a lot the code works great. I am running into an error on a few of the tables. Run-time error '5991'; Cannot access individual rows in this collection because the table has vertically merged cells. None of the first row has vertically merged cells but later on in a few tables this is the cas... 19 Jan 2010 16:58
A macro to bold first row in word tables I have been having an issue with applying new styles to existing tables in Word 2007 stripping away the bolding of the first row which contains the headings for all the columns. Is there a way to loop through the tables and apply this formatting? Also the first table in the document does not need the bold, is there a... 19 Jan 2010 14:41
Locating a specific text box in a section. I have a section 1 of a document that contains 2 text boxes: - Text box 1 contains data fields - Text box 2 contains other data fields in a table. I want to toggle text box 2 so I can display or hide it via a macro. But how do I locate that specific text box (2)? I canm easily hode/show all the text boxes i... 22 Jan 2010 05:06
Is possible to save a .pdf file to Office live with code? Suppose I have create an .pdf file. Is it possible with VBA (I am an Access developer and understand VBA) to send or save that .PDF file to an office live location? I have an office live location that I share with others but I would like to get a .PDF file there without manual intervention. Is this a possi... 18 Jan 2010 21:03
Macro Error Invalid Argument every other run I have a lovely piece of programming done by one of our MVPs here a couple years back that was working great. After many modifications to keep it current, it is now throwing an error every other run. These are all private sub modules in a UserForm that execute when you push a button. H... 18 Jan 2010 21:03
Calculation from results of form fields in VBA I have stumbled (literally) on a solution for calculating the result of a formfield using the results of 2 others: If aDocForm("SupInfBox").Result = "inf" Then aDocForm("IsoSuggest").Result = ((aDocForm("LLWireSetup").Result - aDocForm("ULWireSetup").Result) / 2) + aDocForm("ULWireSetup").Result End If and it w... 21 Jan 2010 14:38
AutoOpen() doesn't run! Hello, I have a Word 2003 document that is opened from an Access 2003 function using the following command. Set objWord = GetObject("K:\My Documents\Winword\MailMerge\Email Receipt.doc", "Word.document") ' Make Word visible objWord.Application.Visible = True This document has an AutoOpen() macro ... 22 Jan 2010 14:06
A macro to increase line spacing I'm trying to make a macro on my Word 2007 "Quick Access Toolbar" that will add 6 points after each line that I've selected. When I record a macro to do this, it adds the 6 points fine, but then sets the indent at "0", which was what the paragraph had when I recorded the macro. What I'd like it to do is ignore ... 17 Jan 2010 17:19
Changing Constants in several macros in one go Dear Experts: For a table macro (see below) I have defined two constants ... .... strConstantBlue: representing the RGB value for borders, .... strConstantBlue_2: representing the RGB value for background pattern color. I got SEVERAL similar table macros all with the SAME constants, i.e. .... strConstantBlue ... 19 Jan 2010 19:14
Borderless form I'm trying to create a borderless and caption bar less form. It is so easy in VB6. Any easy way to do it without API's in VBA (Outlook 2k3)? ... 18 Jan 2010 06:27 |