Search:

Type: Posts; User: Andrew Lockton; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. You don't want a blank paragraph after every...

    You don't want a blank paragraph after every shaded paragraph, just between two shaded paragraphs. The following macro should do that. Note that the oPara.Next will error on the last paragraph so I...
  2. If you are adding/removing the text box then it...

    If you are adding/removing the text box then it would actually be a lot simpler to just hide/show it. This avoids a lot of fiddly work when you need to 'add it back'.
    ...
  3. The separation of white space could be done by...

    The separation of white space could be done by inserting an empty paragraph in between each paragraph but there is another way.

    If you set up your styles with a fill AND and thick white paragraph...
  4. I don't know what processing you want to do but...

    I don't know what processing you want to do but this code will show you how to pick the contacts with a Croquet category

    Public Sub GetListOfContacts()
    Dim Session As Outlook.NameSpace
    Dim...
  5. Does this reference help?...

    Does this reference help?
    https://msdn.microsoft.com/en-us/library/office/ff869662.aspx

    It suggests you use InStr to reveal if your search string appears in the Categories field.
  6. Replies
    3
    Views
    426

    The image is a floating object in the header. If...

    The image is a floating object in the header. If you open up the header you will be able to select that graphic and move it around.

    Now, because you have multiple sections in the document, you...
  7. Do these citation sources not provide an XML...

    Do these citation sources not provide an XML export option?

    If you can get hold of structured data then choosing to show only a subset of that is much easier than trying to anticipate what kind...
  8. Replies
    2
    Views
    338

    You don't need a macro to do this if you layout...

    You don't need a macro to do this if you layout your input data in a table and can implement a formula like http://www.exceltactics.com/faster-multiple-criteria-lookups-vlookup-concatenate/
  9. Have you created custom ribbons before? This...

    Have you created custom ribbons before?

    This link provides an example but if you haven't read the rest of the book (RibbonX Customizing the Office 2007 Ribbon by Robert Martin, Ken Puls, Teresa...
  10. Replies
    1
    Views
    96

    From your description I would say that the first...

    From your description I would say that the first Figures 1: is coming from paragraph numbering attached to the style "Caption".

    You can choose one or the other but the usual way that Word works is...
  11. Paul, I think the setting suggested by jwoods...

    Paul, I think the setting suggested by jwoods would be "Update automatic links at open", but then you probably knew that. :rolleyes:
  12. In my templates I use separate outline lists for...

    In my templates I use separate outline lists for Headings and other list types however this means I need a local restart on each list so the formatting is not fully style-based. A macro to do the...
  13. Replies
    20
    Views
    1,107

    What Doc Management software are you using? We...

    What Doc Management software are you using? We don't normally get questions like this here so a localised search is unlikely to reveal anything but if you put the name of the program into a Google...
  14. [SOLVED] Macropod's code goes very close to doing what you...

    Macropod's code goes very close to doing what you asked. It actually can work with only an insertion point but not if it is positioned at the end of the paragraph which is where I would expect you...
  15. Table styles can be made visible/invisible just...

    Table styles can be made visible/invisible just like any other style. As you have discovered, going into the manage style dialog via the GUI can result in frustration where those table styles are...
  16. Testing whether a file exists is easy enough eg ...

    Testing whether a file exists is easy enough eg

    sFile = "C:\Work\file.xlsx"
    If Dir(sFile) <> "" Then
    MsgBox "File exists."
    Else
    MsgBox "File doesn't exist."
    End If

    HOWEVER: If you...
  17. I'm sure there are more elegant ways of doing...

    I'm sure there are more elegant ways of doing this although you haven't helped with the sheet and filenames logic. Anyway, here is my clumsy first attempt at doing the task. Note that the copy and...
  18. Yes that process can be automated but you will...

    Yes that process can be automated but you will need to provide sample files that are the template and a few sample input documents with instructions on what cells need to be copied and where it goes...
  19. Easy, just rename the Normal.dotm and move it to...

    Easy, just rename the Normal.dotm and move it to your startup folder. You will need to have Word closed in order to do this but then when you reopen Word, a new Normal.dotm will be created to replace...
  20. [SOLVED] By default, macros are disabled if they are...

    By default, macros are disabled if they are contained in templates located in non-trusted locations. When macros are disabled, you can't even view them in the VBA Editor. To avoid this complication,...
  21. [SOLVED] Lets assume all these copies are still in the...

    Lets assume all these copies are still in the User Templates folder. Lets also assume you renamed them by changing their file extension.

    So, you can open any of them by renaming them to end with...
  22. Replies
    2
    Views
    146

    [SOLVED] And so to get rid of it... You can either...

    And so to get rid of it...

    You can either remove the table so you can select it directly or you can go to Home > Select > Select Objects and lasso it and then press delete. The Select dropdown is...
  23. You could make it necessary to enable macros in...

    You could make it necessary to enable macros in order to see the content. For example, if the workbook close event hid the 'wanted' worksheets and a workbook open event showed it then the user would...
  24. Have you made any attempt at this yourself? You...

    Have you made any attempt at this yourself? You can do web searches for the three main components of your request and it would be good to know what you have explored so far.

    Note that in order to...
  25. The setting which is causing this is refreshing...

    The setting which is causing this is refreshing the styles from the 'attached template' when the document is opened. This setting resides in each document and you will need to go into each document...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4