FTP in Excel causes Error 68 
Author Message
 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  
 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  
 
 [ 2 post ] 

 Relevant Pages 

1. What code to use to handle error 68?

2. How come 290,32+69,68=360,000007629395?

3. Like "9[68]0*"

4. Update query will only update 68 rows.

5. relational design for 68,000+ record flat file table

6. Using a data field 01/00/68

7. Why: 8 pages = 68 Megs? (no photos)

8. Repeatable error: Excel caused and IPF in Module Excel.exe@014f:

9. Excel caused a divide error in module EXCEL.EXE at 0137:50334670


 
Powered by phpBB® Forum Software © phpBB Group