Excel Runtime Error 462 The Remote Server Machine
Contents |
360 games PC games run time error 462 the remote server machine does not exist or is unavailable Windows games Windows phone games Entertainment All Entertainment 462 the remote server machine does not exist or is unavailable epacebase Movies & TV Music Business & Education Business Students & educators
Error 462 The Remote Server Machine Does Not Exist Or Is Unavailable
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Run Time Error 462 Excel Vba
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All the remote server machine does not exist or is unavailable vba Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed
The Remote Server Machine Does Not Exist Or Is Unavailable 'createobject'
answers to any questions you might have Meta Discuss the the remote server machine does not exist or is unavailable vbscript workings and policies of this site About Us Learn more about Stack Overflow the company the remote server machine does not exist or is unavailable vb6 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join https://support.microsoft.com/en-us/kb/178510 the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Run-time error 462 : The remote server machine does not exist or is unavailable” when running VBA code a second time up http://stackoverflow.com/questions/33631641/run-time-error-462-the-remote-server-machine-does-not-exist-or-is-unavailable vote 2 down vote favorite The code below is working fine the first time I run it, but when I need to run it a second time, it gives me this error: Run Time error '462': the remote server machine does not exist or is unavailable It doesn't happen all the time so I suppose it has something to do with Word (not) running in the background...? What am I missing here? Sub Docs() Sheets("examplesheet").Select Dim WordApp1 As Object Dim WordDoc1 As Object Set WordApp1 = CreateObject("Word.Application") WordApp1.Visible = True WordApp1.Activate Set WordDoc1 = WordApp1.Documents.Add Range("A1:C33").Copy WordApp1.Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF, _ Placement:=wdInLine, DisplayAsIcon:=False Application.Wait (Now + TimeValue("0:00:02")) WordDoc1.PageSetup.TopMargin = CentimetersToPoints(1.4) WordDoc1.PageSetup.LeftMargin = CentimetersToPoints(1.5) WordDoc1.PageSetup.BottomMargin = CentimetersToPoints(1.5) ' Control if folder exists, if not create folder If Len(Dir("F:\documents\" & Year(Date), vbDirectory)) = 0 Then MkDir "F:\documents\" & Year(Date) End If WordDoc1.SaveAs "F:\documents\" & Year(Date) & "\examplename " &
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/5496294/error-462-in-vba-remote-server-machine-not-found and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it the remote only takes a minute: Sign up Error 462 in VBA : remote server machine not found up vote 0 down vote favorite 1 following code is to read a word file in vba. But its showing an error Error 462 in VBA : remote server machine not found. Sub abc() Dim fileReader As String Dim wrdApp As Word.Application Dim wrdDoc the remote server As Word.Document Dim singleLine As Paragraph Set wrdApp = CreateObject("Word.Application") Set wrdDoc = wrdApp.Documents.Open("C:\Documents and Settings\Administrator\My Documents\Downloads\fwfiles\webs.doc") With wrdDoc Dim p As Paragraph For Each p In wrdDoc.Paragraphs fileReader = p.Range.Text Next p End With End Sub Thanks in advance vba word-vba share|improve this question edited Aug 21 at 17:21 Slai 4,3963919 asked Mar 31 '11 at 7:00 Thomas Mathew 72221026 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Where do your code stop ? Have a look at this link : http://support.microsoft.com/kb/319832/en-us Does it break when you launch it twice ? Have a look here : http://support.microsoft.com/default.aspx?kbid=178510 You could also have a look here : http://www.tek-tips.com/viewthread.cfm?qid=756598 And finally : you should avoid using the with block with a Word Application object you should free your variables (Set ... As Nothing, wrdApp.Close, ...) Hope that helps, Regards, Max share|improve this answer answered Jun 15 '11 at 9:45 JMax 16.5k84469 add a comment| up vote 0 down vote or you can try this shorter version: Function abc() As String doc = "C:\Documents and Sett