Windows 7 FTP Problem on New PC

Flupsie

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]
[FONT=&quot]The following code is highlighted[/FONT]
[FONT=&quot] [/FONT]
wsh.Run FTPcommand, 5, True[FONT=&quot][/FONT]
[FONT=&quot]
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]
 
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
 
Back
Top