Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    20
    Views
    1,472

    You might need to post your current code. I...

    You might need to post your current code.

    I assume that you are using
    zUserName = Environ("UserName")

    Try putting a breakpoint on that line and see what value you get for zUserName when that...
  2. Replies
    20
    Views
    1,472

    Phil Your method of verifying the username...

    Phil

    Your method of verifying the username works only if you know who each user is and what their particular user account has configured their name as. You can check out the relevant information...
  3. Replies
    6
    Views
    254

    Have you looked at...

    Have you looked at
    File>Options>Advanced>Print>Allow fields containing tracked changes to update before printing
    File>Options>Advanced>General>Update automatic links at open
  4. Replies
    6
    Views
    254

    When revision tracking is turned on and you...

    When revision tracking is turned on and you update the fields, this is sometimes shown as a tracked revision.

    You can minimise the effect by turning off the options that update the fields when...
  5. Replies
    20
    Views
    1,472

    I've had a look at it and tidied the code up to...

    I've had a look at it and tidied the code up to remove the massive amounts of duplication. I generally prefer to use the properties of the controls themselves to make the VBA code a lot shorter. In...
  6. Perhaps File1 was a macro used by jrklein which...

    Perhaps File1 was a macro used by jrklein which is why is used to work.
  7. In the words of Ron Burgundy... 'Well, that...

    In the words of Ron Burgundy... 'Well, that escalated quickly' :(

    Atelby12 - if you are planning on distributing a 'global macro' then you ARE working with a template whether you want to or not....
  8. Replies
    17
    Views
    1,463

    I would do this by trapping the double click...

    I would do this by trapping the double click event on a worksheet and taking the cell value as the name of the sheet that needed to be activated. The following macro can be added to any worksheet...
  9. There are different types of styles. I don't use...

    There are different types of styles. I don't use List styles because IMO they are pointless. However, I do use Paragraph styles and associate them with outline lists. It is the paragraph style that...
  10. The code can be written multiple ways to allow it...

    The code can be written multiple ways to allow it to work on other computers. Personally, I would place the graphics into the template itself as building blocks so there is no need to import them...
  11. Yes, it would make a lot of sense to do that. I...

    Yes, it would make a lot of sense to do that. I was assuming that the bookmarks and cross-refs already existed in the document but if you are yet to add them then your suggestion is easily the best...
  12. Word cross-references to numbered items are...

    Word cross-references to numbered items are ACTUALLY created by using the same 'add a bookmark then insert a field that links to that bookmark' that you are trying to identify. So you need to be very...
  13. Spaces between paragraphs should be done by...

    Spaces between paragraphs should be done by modifying the style's paragraph attributes to include a space before and/or after the paragraph.
  14. Darren FWIW, I agree with Charles that you...

    Darren

    FWIW, I agree with Charles that you really should be using styles. The major problem with doing it without styles is that you can't run the macro a second time on the same document.
    ...
  15. There is some grey in what you asked for but this...

    There is some grey in what you asked for but this macro should show you how it can be done. Your before doc shows three different indents on your bullets but your after doc has turned this into two....
  16. Darren You can do whatever you like but if you...

    Darren

    You can do whatever you like but if you are not using styles then you will always have to manage global updates by some dodgy macro method like that above. If you start using styles then...
  17. The macros you need are not particularly...

    The macros you need are not particularly difficult to code. The trick is finding an attribute of each paragraph that uniquely identifies the style that should be applied to it. For instance, if you...
  18. [SOLVED] Paul Yes, you are right. it looks like Shelley...

    Paul
    Yes, you are right. it looks like Shelley is saying that the fee earners write on paper copies and then scan this as PDFs for back-office staff to implement these changes to existing Word...
  19. [SOLVED] I would recommend investigating Content Controls...

    I would recommend investigating Content Controls too. Paul's arguments against CCs are well founded but Shelley's case may still suit Content Controls quite well.

    The 'fee earners' appear to be...
  20. Try With Selection.Find .ClearFormatting ...

    Try

    With Selection.Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = " ([0-9])"
    .Replacement.Text = "^s\1"
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
  21. Try this macro Sub HardSpaceBeforeCrossRefs()...

    Try this macro

    Sub HardSpaceBeforeCrossRefs()
    Dim aField As Field, rng As Range
    For Each aField In ActiveDocument.Fields
    If aField.Type = wdFieldRef Then
    Set rng = aField.Result...
  22. Replies
    13
    Views
    1,152

    This seems to work Select your content Open...

    This seems to work

    Select your content
    Open the VBA Editor by pressing Alt-F11
    Open the Immediate Window in the VBA Editor by pressing Ctrl-G
    Type the following line in the Immediate Window and...
  23. Replies
    13
    Views
    1,152

    I had a further look at the problem content and...

    I had a further look at the problem content and it is definitely language related. If I select those two characters I can see in the status bar that it is spell checked in Hebrew but the words around...
  24. Replies
    13
    Views
    1,152

    Well ain't that a weird one. Without determining...

    Well ain't that a weird one. Without determining what causes the problem it looks easy enough to fix. If I copy that paragraph and then do a Paste Special as Unformatted text then I get a paragraph...
  25. Replies
    13
    Views
    1,152

    Is this related to a language setting with a...

    Is this related to a language setting with a document language that runs right-to-left instead of the english left-to-right?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4