Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

FTP through Excel 2007 halts on random systems

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.
Thanks
PR
0
PointRollIT
Asked:
PointRollIT
1 Solution
 
AlexPaceCommented:
Is your FTP client capable of producing a log file?  Maybe it will show the problem.
0
 
dlonganCommented:
How about how the security setup in excel's 'trust center'
0
 
PointRollITAuthor Commented:
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?
0
 
AlexPaceCommented:
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"

:find_file 
GETNEXTFILE "*" /timeout=0 
IFERROR= $ERROR_WAIT_TIMED_OUT GOTO find_file
 
:upload 
FTPLOGON "ftp.new.com" /user=anonymous /pw=itchy 
IFERROR!= $ERROR_SUCCESS GOTO upload_error 
SENDFILE %nextfile 
IFERROR!= $ERROR_SUCCESS GOTO upload_error 
FTPLOGOFF 
DELETE %nextfile 
GOTO find_file 

:upload_error 
FTPLOGOFF 
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.
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now