Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    3
    Views
    225

    David From your description it sounds like the...

    David

    From your description it sounds like the grey shading is an indication that the text is contained in a field. The field is most likely a pasted link to the source document where it was...
  2. [SOLVED] I suspect you would have to unmap your drive so...

    I suspect you would have to unmap your drive so that the filename field is forced to display the full path.
  3. Replies
    7
    Views
    1,954

    Add a line after ActiveDocument.Fields.Update ...

    Add a line after
    ActiveDocument.Fields.Update

    The line should just have the name of the macro you want to run eg


    ActiveDocument.Fields.Update
    RemoveDocVarFieldsWithNoDocVars
  4. Alice I may be wrong but I think that layout...

    Alice

    I may be wrong but I think that layout is not really going to be workable with a mail merge solution. Instead, I would investigate other alternatives:
    - Microsoft Access Report
    - Word...
  5. Replies
    7
    Views
    1,954

    I would either use content controls and an...

    I would either use content controls and an embedded xml file linked to those CCs or just get the vba to do whatever alterations to the content you require. Since you are using VBA anyway you might as...
  6. Are you open to using a macro for this...

    Are you open to using a macro for this
    http://www.pcreview.co.uk/threads/check-boxes-not-working-w-cross-reference.879772/
  7. I would be checking on the option for the...

    I would be checking on the option for the attached template to see if the styles are set to refresh when opening. If style changes don't stick this is usually the issue.
  8. IMO, Floating shapes or text boxes is rarely a...

    IMO, Floating shapes or text boxes is rarely a good idea and I certainly wouldn't use them in this situation.

    I would suggest trying a tabular layout. On the last page option I would put the...
  9. It is possible that we can work out what type of...

    It is possible that we can work out what type of object the text comes from but without seeing the actual presentation file I can't be sure it would work.

    The fact that you can isolate the...
  10. There is probably a more efficient way to do this...

    There is probably a more efficient way to do this but this appears to work

    Sub GoGetEm()
    Dim curSlide As Slide
    Dim curShape As Shape
    Dim curNotes As Shape
    Dim oSh As Shape

    For...
  11. I would have thought that you would do this by...

    I would have thought that you would do this by automating Adobe Acrobat. There is a command in Acrobat that captures a url as a PDF. You could then use VBA from Word to read the table and automate...
  12. Replies
    2
    Views
    189

    Where is the macro saved? Is it in a document or...

    Where is the macro saved? Is it in a document or a template?
  13. Replies
    8
    Views
    1,075

    What macro did you put the code in? You need to...

    What macro did you put the code in? You need to initialise the form if you want the fields to be populated when the form loads?
  14. Replies
    8
    Views
    1,075

    If I create a userform in that doc then the...

    If I create a userform in that doc then the following works for me

    Me.TextBox1 = ActiveDocument.CustomDocumentProperties("Klantnaam")
  15. Replies
    8
    Views
    1,075

    Can you post a sample document that contains this...

    Can you post a sample document that contains this custom property? I would be surprised if a space was allowed in the name.
  16. Jessica Your code is almost there. You have...

    Jessica

    Your code is almost there. You have named both documents so that part is taken care of but then you go back to using ActiveDocument and Selection which gets confusing.

    For starters -...
  17. Can you share the code so we can see what the...

    Can you share the code so we can see what the problem might be? Depending on how the code might be written, it is possible that the ActiveDocument changing as a second file opens is what is causing...
  18. Replies
    8
    Views
    1,075

    What research have you done on this problem? Do a...

    What research have you done on this problem? Do a quick google search to find further resources and get your level of knowledge up a bit. Here are some useful links to get you started......
  19. Replies
    9
    Views
    642

    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"
  20. Replies
    9
    Views
    642

    What version of Excel are you using?

    What version of Excel are you using?
  21. Replies
    9
    Views
    642

    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...
  22. Thread: Bullets

    by Andrew Lockton
    Replies
    3
    Views
    237

    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....
  23. 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...
  24. Replies
    9
    Views
    642

    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 &...
  25. Replies
    1
    Views
    178

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4