Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.09 seconds.

  1. Try the following. Your input sheet was not well...

    Try the following. Your input sheet was not well organised (in terms of column titles and used range) so I explictly named the address of the region where the names can be found. You will need to...
  2. Balbeer If you do a google search for...

    Balbeer

    If you do a google search for 'scrolling marquee excel vba' then you will see that others have asked this question and there are plenty of examples of how people have tried to solve this....
  3. I haven't ever noticed this behaviour and it is...

    I haven't ever noticed this behaviour and it is very odd.

    I did a search and found that this has been documented in at least one place http://wordfaqs.mvps.org/formatcrossreferences.htm so it must...
  4. I don't know why Word is not smart enough to work...

    I don't know why Word is not smart enough to work this out for you but it appears that both the shape fill and the text colour are using the 'Background 1' colour in the color theme. If you change...
  5. Replies
    2
    Views
    121

    FWIW, I am not a fan of including the preview for...

    FWIW, I am not a fan of including the preview for documents.

    If the cover page contains a bitmap then the preview can add over 1Mb to the file size since the preview of the entire cover appears to...
  6. Replies
    1
    Views
    92

    By default F9 updates the selected fields. Your...

    By default F9 updates the selected fields. Your problem is not well described but it sounds like F9 was used for something else on your previous machine. This customised behaviour was probably stored...
  7. The only tool I have seen in this space is the...

    The only tool I have seen in this space is the Sant Proposal Generator and that was 10-15 years ago. I think that product has morphed into this tool...
  8. There are several possible ways to achieve this....

    There are several possible ways to achieve this.

    Personally I would do this by inserting Content Controls and linking them to a custom xml file. This is best done by using a third party tool -...
  9. Replies
    2
    Views
    162

    When you say 'blacked out' do you mean that the...

    When you say 'blacked out' do you mean that the space where the number should be is a black rectangle? If so, could it be a font issue?
  10. Replies
    2
    Views
    175

    When you copy text from the 'net it is generally...

    When you copy text from the 'net it is generally a good idea to Paste Special as text only. This avoids getting any unwanted formatting extras added from the webpage. Use the dropdown on the Paste...
  11. Replies
    2
    Views
    201

    Try opening Word in Safe Mode by holding down the...

    Try opening Word in Safe Mode by holding down the Ctrl key while opening Word. If this allows Word to work happily without the slowdown you describe then it is a safe bet that one of your add-ins or...
  12. Have a very careful read of this webpage...

    Have a very careful read of this webpage
    http://shaunakelly.com/word/numbering/numbering20072010.html

    Note that if you need to revisit ANY heading outline level then you MUST ALWAYS put your...
  13. Replies
    2
    Views
    433

    If you code is too slow, the first thing to...

    If you code is too slow, the first thing to address is your use of the Selection object. This would be faster to use Ranges. If you set an initial address you can use offset in both rows and columns...
  14. Replies
    4
    Views
    313

    Chuck Have a look at File > Options > Save >...

    Chuck

    Have a look at File > Options > Save > Save files in this format:

    What is that set to?
  15. In your code, there are only two possible values...

    In your code, there are only two possible values for SelRangeArr(rngCnt). You declared this variant array variable so it that rngCnt can only be 0 or 1.

    To build a loop to see each of these values...
  16. Peter In that case, I don't know why you are...

    Peter

    In that case, I don't know why you are trying to populate the data into the userform at all. Any of your subsequent analysis and graphing would require the data somewhere else so you may as...
  17. I am not sure I am understanding what you...

    I am not sure I am understanding what you actually want to do with the output but...

    Have you thought of using either a listbox or combobox control to display your output info. You can add an...
  18. Every document has an attached template. If you...

    Every document has an attached template. If you set the attached template to nothing then the 'Normal template' is the attached template.

    Despite the dotx file itself containing no macros when...
  19. In my mind typing "pretty" is 6 different actions...

    In my mind typing "pretty" is 6 different actions so I am surprised you don't just get a 'y'. I just tested this on my Word 2010 and surprisingly I got the entire word to appear (including a space)....
  20. And can you tell us about the document's attached...

    And can you tell us about the document's attached template location? Is that trusted?
  21. Is it only the style definitions that has changed...

    Is it only the style definitions that has changed or is there content changes as well?

    You will need a macro to update the content changes but refreshing the styles from the template is much more...
  22. The WriteCustomProp should be amended to ...

    The WriteCustomProp should be amended to

    Function WriteCustomProp(sProp As String, sValue As String, iType As Integer)
    Dim prop As DocumentProperty, bExists As Boolean
    bExists = False
    For...
  23. The major problem I can see is how you are...

    The major problem I can see is how you are calling the WriteCustomProp function. It is expecting three inputs - String, String, Integer. You don't need to use brackets since this function is not...
  24. Replies
    3
    Views
    318

    It is most likely an Excel spreadsheet which just...

    It is most likely an Excel spreadsheet which just happens to have been named that way. Filenames are very arbitrary and you can name files in any way you like - in this case the docx is just part of...
  25. The benefit of modifying the style for your...

    The benefit of modifying the style for your tables is that new tables created will already have the same table row setting applied so you wouldn't need to continually run the macro to ensure all...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4