Search:

Type: Posts; User: caracolesa; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    676

    Thank you! Once again, I was trying to get too...

    Thank you! Once again, I was trying to get too complicated, and it was something really simple. Thanks!
  2. Replies
    2
    Views
    676

    OR function in Find and Replace?

    Hi guys,

    I've got the following code, which I created with your help a few months ago. It searches a Word document for instances of Doc IDs in a format <[A-Z]{3,}.[0-9]{4}.[0-9]{4}.[0-9]{4}, and...
  3. Thanks Paul! You're an absolute genius! Here I...

    Thanks Paul! You're an absolute genius! Here I was, trying to mess around with the code, and all I had to do was that. So simple! Silly me. Thank you!!
  4. Replace text in footnotes with hyperlinked text

    Hi guys,

    I've got documents where I need to search through and hyperlink any text which follows a particular formula. This is the code:


    Sub AddHyperlinks()
    Application.ScreenUpdating =...
  5. Thank you so much, Paul! You're a champion!

    Thank you so much, Paul! You're a champion!
  6. Thank you so much, Paul! That worked a treat. ...

    Thank you so much, Paul! That worked a treat.

    And now just for an extra bit: if I wanted to change the wildcard to be "at least 3" for the letters in the reference, how can I edit the code for...
  7. Word 2010 - Macro to search for wildcards, replace with hyperlink

    Hi guys,

    I'm hoping someone can help me with this. Ordinarily, I can start coding once I've found a few similar things, and then I just sort of merge stuff together and edit it until it does what...
  8. Thanks for your reply, Andrew. I'll have a play...

    Thanks for your reply, Andrew. I'll have a play with a few different options then, and see what I can come up with.

    Thanks!
  9. Hi Andrew! Excellent! I love learning new...

    Hi Andrew!

    Excellent! I love learning new things!

    Ok, so this is the basis of the project: the client has a suite of documents, which are all kept in the same directory as this spreadsheet. ...
  10. Hi Andrew! Thanks so much for your help. Your...

    Hi Andrew!

    Thanks so much for your help. Your answer has helped me realise that I'm probably making things more difficult than they need to be.

    Essentially, all of the columns in the sheet...
  11. Userform for Mail Merge (Excel) Multiple Records, Single Document

    Hi uber geniuses!

    I've got a couple of queries, but I've separated them across different threads - I hope that's ok! I thought it would make it easier.

    For this one, I need to be able to have...
  12. Userform for mail merge (Excel): single record, multiple documents

    Hi uber geniuses!

    I've got a couple of queries, but I've separated them across different threads - I hope that's ok! I thought it would make it easier.

    For this one, I need to be able to have...
  13. SpinButton to automatically add columns

    Hi uber geniuses!

    I've got a couple of queries, but I've separated them across different threads - I hope that's ok! I thought it would make it easier.

    For this one, if I were to make the...
  14. Userform - Make fields visible based on the number chosen from spinbutton

    Hi uber geniuses!

    I've got a couple of queries, but I've separated them across different threads - I hope that's ok! I thought it would make it easier.

    For this one, I need to only make...
  15. Thanks Andrew - I guess that's why I didn't find...

    Thanks Andrew - I guess that's why I didn't find any references to it - I was only searching through the last year. Thanks for your solution. It will make it somewhat quicker. Out of interest, any...
  16. Thanks for the reply, Jess! I've obviously not...

    Thanks for the reply, Jess! I've obviously not explained myself very well.

    Yes, the document uses Word's outline numbering, and yes, I could go through the 1000+ clause references and...
  17. Automatic cross referencing in a large document

    Hi geniuses!

    I've done some extensive searching on this site, and the web generally, and can't seem to find anything relevant (or even anyone asking the same question, which is odd!).
    ...
  18. Replies
    3
    Views
    591

    Thanks Andrew! I'll see how they go and let you...

    Thanks Andrew! I'll see how they go and let you know.
  19. Replies
    3
    Views
    591

    Actually, I have a userform which already...

    Actually, I have a userform which already generates much of this information, which I could modify. How would I go about modifying it to include multiple selections, and images?
  20. Replies
    3
    Views
    591

    Fun with Databases/Images!

    Hi guys,

    I need your expertise, because my brain has melted!

    I'm putting together a suite of templates in Word 2010. So far, I haven't had to use any VBA, but I think this one will probably...
  21. Replies
    5
    Views
    2,433

    Thanks for that guys! The issue is, is that if...

    Thanks for that guys!

    The issue is, is that if that particular style is not in the document I'm working on, the macro won't run properly. I just get a 5834: Item with specified name does not...
  22. Replies
    5
    Views
    2,433

    IF statement not working - Word VBA

    Hello oh mighty geniuses of VBA!

    I need some more help.

    I'm trying to code a macro which will run through a document changing styles over to another code. I have about 80 documents which I...
  23. Thanks Paul! You're a champion! Once I change...

    Thanks Paul! You're a champion!

    Once I change AttachedTemplate.Name = strTmplt to AttachedTemplate = strTmplt, it worked a treat!

    Genius!
  24. Almost! Now it stops at the oSty.Delete part of...

    Almost! Now it stops at the oSty.Delete part of If InStr(StrSty, "|" & oSty.NameLocal & "|") = 0 Then oSty.Delete

    It's a run time error 4198 command failed.
  25. Hi Paul, Thanks for that! It runs fine...

    Hi Paul,

    Thanks for that!

    It runs fine until "Set DocTmp = Documents.Add(Template:=.AttachedTemplate, Visible:=False)" and then I get run time error '13' Type mismatch. Any ideas?
Results 1 to 25 of 27
Page 1 of 2 1 2