Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. This might be what you want Sub...

    This might be what you want

    Sub GetResourceTitle()
    'Application.ScreenUpdating = False
    Dim strFolder As String, strFile As String, strDocNm As String, wdDoc As Document
    Dim aDoc As...
  2. I found a post on another forum that works when...

    I found a post on another forum that works when adapted to the information you posted by PM

    http://stackoverflow.com/questions/17877389/how-do-i-download-a-file-using-vba-without-internet-explorer...
  3. If you haven't sorted it out yet, PM the actual...

    If you haven't sorted it out yet, PM the actual info to me and I'll have a look to see if I can help.
  4. Charles, yes you are correct. I'll go back and...

    Charles, yes you are correct. I'll go back and edit that post to correct my clumsiness.
  5. When downloading the file manually, are you...

    When downloading the file manually, are you challenged for the username and password before you navigate to the file and download it? Or is it a single step process.
  6. You are testing...

    You are testing Options.DefaultFilePath(wdUserTemplatesPath) contains the template but then don't use that folder to assign the template. It doesn't really matter what path you tell Word the template...
  7. Macros can be located in a wide range of files so...

    Macros can be located in a wide range of files so your question is difficult to answer without seeing your setup. QAT customisations can also be stored in a variety of locations and the location...
  8. Replies
    10
    Views
    274

    Excel uses Visual Basic for Applications. This is...

    Excel uses Visual Basic for Applications. This is an application-specific dialect of Visual Basic (ie follows the same rules but includes terminology specific to the application). If you want to...
  9. Replies
    10
    Views
    274

    Twenty years is a long time to wait for something...

    Twenty years is a long time to wait for something you need. Congratulations on your impressive patience. This was also the time that MS was introducing VBA and phasing out WordBasic so I'm thinking...
  10. Replies
    5
    Views
    206

    Change the line If Len(sID) 6 Then to If...

    Change the line
    If Len(sID) <> 6 Then

    to
    If Len(sID) < 6 or Len(sID) > 7 or Left(sID,2) <> "BM" Then
  11. As Paul says, the code wouldn't work on any...

    As Paul says, the code wouldn't work on any version of Word as it currently stands. It needs a substantial cleanup to get it working (again?). All the variables need to be defined in the subs where...
  12. Replies
    5
    Views
    206

    Try this. Note that the initial search string was...

    Try this. Note that the initial search string was slightly modified to avoid the PDF series also finding the HTM series strings


    Sub DocHyperlinks()
    ' Macro to insert Document hyperlinks
    ...
  13. I don't think Word writes to the MRU list until...

    I don't think Word writes to the MRU list until you save the document. This should mean that Word has to harvest both the MRU and the currently open documents to build the list it shows. My machine...
  14. I thought you might also be able to directly...

    I thought you might also be able to directly clear and write the list entries but I haven't found the right method yet. Something like this might get you started if you wanted to explore this...
  15. I would assume that the list comes in part from...

    I would assume that the list comes in part from the "Recently used" files stored in the registry. Perhaps you could wipe the list by clearing the registry list prior to opening the dialog. This is a...
  16. Does the file with the embedded photos contain...

    Does the file with the embedded photos contain ANY macros? What about it's attached template?

    Also, as suggested by BHarder, did any Word updates get installed in the hour of fiddling around.
  17. They may have a macro which hijacks the Print...

    They may have a macro which hijacks the Print Command. Such a macro could be in any of the active documents or addins.

    To eliminate this possibility, have the start Word in Safe Mode and try...
  18. From your description of the problem, perhaps...

    From your description of the problem, perhaps Word is not the best tool for the job. I know this is sacrilege to suggest it since I'm sure a vba-coded solution could be workable but the output...
  19. Replies
    25
    Views
    555

    Phil IMHO, your userform is an answer in...

    Phil

    IMHO, your userform is an answer in search of a problem. The actual worksheet your form reads/writes to should be where the users put all their data. You can reformat it a bit to make is...
  20. Replies
    25
    Views
    555

    Phil Maud's code is actually independent of...

    Phil

    Maud's code is actually independent of the 'type' for each control. It just so happens to coincide with default names given to controls added to a userform. You have already renamed all your...
  21. Replies
    25
    Views
    555

    Phil It works on my machine by double clicking...

    Phil

    It works on my machine by double clicking to open so the issue might be local to your machine. Perhaps you have multiple versions of this running.

    Interestingly, it appears creating a new...
  22. Replies
    25
    Views
    555

    The userform doesn't retain the data but it can...

    The userform doesn't retain the data but it can load it from the same sheet that is populated by the userform anytime.
    See the attached version of your workbook. You have lookup lists already setup...
  23. Replies
    25
    Views
    555

    You need to refer to the worksheet in the same...

    You need to refer to the worksheet in the same way it was done earlier in the same macro
    ActiveWorkbook.Worksheets("Monthly Report")

    And I'm not sure why you want to .Select the sheet. I would...
  24. Are they all really TOCs? Sub GotoRange() ...

    Are they all really TOCs?

    Sub GotoRange()
    Dim aRng As Range
    Set aRng = ActiveDocument.TablesOfContents(ActiveDocument.TablesOfContents.Count).Range
    aRng.Collapse Direction:=wdCollapseEnd...
  25. You can recover some content by using Word 2010...

    You can recover some content by using Word 2010 if you open Word and then go to File > Open and browse to the file; change the file type to Recover Text from Any File and click Open

    The file 82...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4