Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    9
    Views
    138

    So am I so that is not the problem. Does it...

    So am I so that is not the problem.

    Does it give the same error if you change the FilePath line to the following?

    FilePath = "C:\Test.txt"
  2. Replies
    9
    Views
    138

    What version of Excel are you using?

    What version of Excel are you using?
  3. Replies
    9
    Views
    138

    Note that using the contents of a cell to...

    Note that using the contents of a cell to determine the filename could be a problem if that cell contains characters that are not allowed in a filename eg /


    Sub WriteTextFile3()
    Dim FilePath...
  4. Thread: Bullets

    by Andrew Lockton
    Replies
    3
    Views
    74

    You can either define the list to leave a greater...

    You can either define the list to leave a greater space for the indented text or you could choose to right align the list elements so they expand to the away from the text rather than towards it....
  5. Is the Import workbook supposed to already exist?...

    Is the Import workbook supposed to already exist?

    If so, where is it and what do you want to do if it already contains a worksheet with the same name? Does the Import Workbook already contain...
  6. Replies
    9
    Views
    138

    Try this alternative method. Sub...

    Try this alternative method.

    Sub WriteTextFile2()
    Dim FilePath As String, LastRow As Long
    Dim aSht As Worksheet, aShtSrc As Worksheet

    FilePath = Application.DefaultFilePath &...
  7. Replies
    1
    Views
    84

    A macro would be relatively simple but it is...

    A macro would be relatively simple but it is going to be complicated by how you plan to handle less common names such as "Li Na", "George St Clair", "Mary-Lou Van Houten" etc

    Can you explain the...
  8. Replies
    24
    Views
    1,565

    Thanks for the info Pam. Yes, this thread has...

    Thanks for the info Pam. Yes, this thread has evolved a long way from the original question.

    I haven't seen what you describe and I wasn't even aware that there was such a thing as the 'default...
  9. Replies
    24
    Views
    1,565

    I've always been an avid user of the 'Normal'...

    I've always been an avid user of the 'Normal' style. I don't know what problems you had in Word 97 but I am guessing that 18 years later perhaps your knowledge of styles has grown. IMO, the cascading...
  10. I don't get an error on the document you posted....

    I don't get an error on the document you posted. Are you testing the macro on a different document?
  11. Try the following Sub...

    Try the following

    Sub RemoveUnwantedParagraphs()
    Dim iPar As Integer
    Dim oPar As Paragraph
    Dim aShp As InlineShape

    ActiveDocument.Styles("Caption").ParagraphFormat.OutlineLevel =...
  12. Looking at the content of your sample document,...

    Looking at the content of your sample document, it appears that the Headings are to be retained and the 'Normal' paragraphs outside of tables need to be deleted.

    It is certainly possible to do...
  13. Replies
    7
    Views
    473

    Now we see the first mention that you are using a...

    Now we see the first mention that you are using a userform.

    So is the question now - how do I populate a listbox from a text file? Or is it how do I read and write a text file in vba?
  14. Shenquila There are multiple ways to do this...

    Shenquila

    There are multiple ways to do this automatically but we need to understand what you want in the cell. Do you want the entire embedded Word document or just the text contained in it?
    ...
  15. The pattern you suggested won't match any of the...

    The pattern you suggested won't match any of the tables in your sample so I changed it to something that does match some of the tables you provided.

    Sub temp()
    Dim aTbl As Table
    Dim str As...
  16. You are doing something that most people would...

    You are doing something that most people would consider very odd - putting an entire Word document into a single cell in excel doesn't sound particularly useful. If the content is unreadable because...
  17. Replies
    7
    Views
    473

    So what is your plan for how it would work from...

    So what is your plan for how it would work from the users point of view? Do you want a way of categorising MRU files or do you want to define which list is currently active. How do you plan to switch...
  18. Replies
    7
    Views
    473

    I don't have the book and so I'm not sure what...

    I don't have the book and so I'm not sure what you actually want multiple MRU lists to achieve for you. I would have thought that it would be more useful to revisit this with the ribbon of Word 2007+...
  19. I don't know of a way to align the decimals on...

    I don't know of a way to align the decimals on the leading numbers without including a tab at the start of the paragraph. This would require editing of the TOC each time after it is refreshed.

    It...
  20. The code is failing because when you get to the...

    The code is failing because when you get to the last paragraph in the document there is no next paragraph.

    You could modify the if statement along the lines of
    If notag is nothing then
    'do...
  21. Replies
    24
    Views
    1,565

    Arowland It would be great to see a good...

    Arowland

    It would be great to see a good solution to the end of list spacing. I have always used an empty paragraph with a style we call 'Spacer' for instances such as this but it is a kludge...
  22. You may have pasted the same code into the...

    You may have pasted the same code into the template twice. Do a debug or compile and check what line is highlighted and see if you can find the relevant name defined elsewhere in the code.
  23. [SOLVED] Charles Thanks for doing the comprehensive...

    Charles
    Thanks for doing the comprehensive testing and showing us the results.
  24. There is probably a cleaner way to do this but if...

    There is probably a cleaner way to do this but if you added the following two lines to the end of that macro then the image would be at the bottom of the page

    shpCanvas.RelativeVerticalPosition =...
  25. Replies
    24
    Views
    1,565

    Arowland There is a very big difference...

    Arowland

    There is a very big difference between "Word can't do" and "I don't know how to make Word do". Yes, Word is not a page layout program but the when it comes to authoring content it is the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4