Help with VBA and FTP that does not work anymore

HunterN

Active Member
Joined
Mar 19, 2002
Messages
479
Hi!

A little information first, in June 2005 we converted to Windows XP and ever
since the following has not worked!

We use to be able to ftp files over to the UNIX server with the following commands in VBA.

Sub()
' oletest is the name of the FTP application
Dim oletest As Object

' define the FTP session
Set oletest = CreateObject("FTPSFtp.Application")

.
. ( more lines in between)
.

End Sub

Now the SET gives an error of:

Run-time error '429':

ActiveX component can't create object


Does anyone know what could cause this? I really wish I could automate
it again to FTP the file over to the UNIX machine.

:confused:

Thanks, Nancy
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,767
Members
412,291
Latest member
marypolitan
Top