FTP through Excel 2007 halts on random systems

Posted on 2011-03-25
Medium Priority
Last Modified: 2012-08-13
I have about 200 users that run a specific macro that has an FTP call. The usernames and passwords are supplied and it works for 90 percent of the people.
***The credentials are the same for everyone***
The other 10 percent have Excel freeze during the FTP call. They can reach the FTP through FTP clients or browsers, but the Macro in the spreadsheet will not work.
They are all running Windows 7 with Excel 2007, and there is no difference in physical hardware.
Any help or ideas will be greatly appreciated.
Question by:PointRollIT
LVL 16

Expert Comment

ID: 35219903
Is your FTP client capable of producing a log file?  Maybe it will show the problem.

Expert Comment

ID: 35220115
How about how the security setup in excel's 'trust center'

Author Comment

ID: 35259120
Thanks for the fast response...

Log files only show that the FTP call is stopped. There are no error messages or any clues.

The Trust Center was the first thing we looked into. Unfortunately we cannot add an FTP site to the Trust Center, but all local resources have been added.

Any other ideas?
LVL 16

Accepted Solution

AlexPace earned 2000 total points
ID: 35260556
I have an idea that will cost money but will work If all of your users are on the same internal network and they all use the same username / password on the remote FTP server ...

Set up a network share and allow everyone to write to it.  Then set up a "hot send" service using Robo-FTP.  This will monitor the folder and automatically upload any files that appear.  Then modify your Excel macro to copy the file to be sent to this network share instead of using FTP from the individual machine.  Then you only have to worry about maintaing the FTP connection from one server.  Also you get the advantages of protocol-level logging if you need to troubleshoot and automatic retries if there is a transmission error.  Here is a sample Robo-FTP command script for implementing a "hot send" folder:
LOG "hot_send_script.log"
TRACELOG "hot_send_trace.log"
WORKINGDIR "c:\data\source\folder"

GETNEXTFILE "*" /timeout=0 
FTPLOGON "ftp.new.com" /user=anonymous /pw=itchy 
SENDFILE %nextfile 
DELETE %nextfile 
GOTO find_file 

GETNEXTFILE %nextfile  
IFERROR= $ERROR_SUCCESS GOTO upload  ; if file exists try to upload 
GOTO find_file     ; file no longer exists so find another file

Open in new window

If some of your users are mobile and might be trying to use this macro remotely whileout a VPN into your network you could add a little test in the macro to see if it has access to the shared hot send folder and if that folder is unreachable fall back to your existing FTP method.
LVL 24

Expert Comment

ID: 35821698
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question