“Run-time error 462 : The remote server machine does not exist or is unavailable” when running VBA code a second time and there after

  • I am trying to run below macro but get a "Run-time error 462 : The remote server machine does not exist or is unavailable” with line 12 highlighted on the debug of below code.

    I have searched all over for a resolution, any help and support would be much appreciated.


  • Is this code in Word or Excel? If it's in Excel it needs quite a few changes to work properly.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • You need a Word.Application object then:


    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Hi Rory, that works as should thanks very much.

    I have another thread on here with the same problem which includes the prior sub routine to this one as attached. I have it listed as "Highlight key words and paragraphs in all word documents in a set folder" to which i am getting the same error message. That script was also not designed for excel, but need it to suit my needs.

    Do you think you could do your magic on that thread as well please with it being the same error message? the debug is highlighting :-Pre redaction tool.xlsm


    Code
    1. Set oDoc = Documents.Open(FileName:=sFldr & vFile)

    Pre redaction tool.xlsm

  • Hi Rory,


    I have managed to resolve my last issue based on your previous post. Thanks again.


  • Good work! :)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why