FTP Problem on New PC


Well-Known Member
[FONT=&quot]I have the following FTP code which works perfectly on my one PC at the office. I have just been given a new PC and when running the macro run time error 440 "unable to wait for process"

[FONT=&quot]The following code is highlighted[/FONT]
[FONT=&quot] [/FONT]
wsh.Run FTPcommand, 5, True[FONT=&quot][/FONT]
I am using Office 2010 and Windows 7 on both PC's

I suspect that it may have to do with a Windows setting of some sort.

Your assistance in resolving the problem will be most appreciated

Public Sub Ftp_Download_File()

Dim FTPcommand As String
Dim wsh As Object

FTPcommand = "ftp -n -s:" & Chr(34) & "C:\FTP_commands2.txt" & Chr(34)
Set wsh = CreateObject("WScript.Shell")
wsh.Run FTPcommand, 5, True

End Sub [/FONT]

[FONT=&quot] [/FONT]


Well-Known Member
Just to let the users know that i have resolved the problem. I went to the Control Panel, Internet Options and clicled on Security and set the Local Intranet to a low setting and it has now allowed me to download the file

This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.