Excel, FTP in Excel causes Error 68

FTP in Excel causes Error 68

Author	Message
Beatt #1 / 2	FTP in Excel causes Error 68 - I have an application written in VB 6.0 which is called from Excel. This application allows the current Excel worksheet to be FTP'ed to our VAX mainframe. - This application works fine on Windows 98 but when we upgrade to Windows 2000 I get the an Error Window popup Sheet1.ExportData_Click Error 68: OK - I have located the line of code it is failing on : Sheet1.Socket1.RemotePort = IPPORT_FTP - IPPORT_FTP is defined as follows : Public Const IPPORT_FTP=21 thanks for any assistance
Sat, 04 Jun 2005 06:55:23 GMT

Jake Mar #2 / 2	FTP in Excel causes Error 68 Hi Beatto, I assume you're using a 3rd party control (maybe socketwrench?), which is causing the issue. Make sure you have the most current release of the control you're using (one that is tested for Windows 2000). If you are using socketwrench, this may help: http://www.socketwrench.com/support/faq/socketwrench.html#wrench20 Regards, Jake Marx MS MVP - Excel Quote: > - I have an application written in VB 6.0 which is called > from Excel. This application allows the current Excel > worksheet to be FTP'ed to our VAX mainframe. > - This application works fine on Windows 98 but when we > upgrade to Windows 2000 I get the an Error Window popup > Sheet1.ExportData_Click > Error 68: > OK > - I have located the line of code it is failing on : > Sheet1.Socket1.RemotePort = IPPORT_FTP > - IPPORT_FTP is defined as follows : > Public Const IPPORT_FTP=21 > thanks for any assistance
Sat, 04 Jun 2005 09:00:45 GMT

Page 1 of 1

[ 2 post ]