If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel 2007 Freezes on SaveAs to FTP site on one computer, not others?

Thread starter ratt2581
Start date Mar 9, 2011

ratt2581

Board Regular

Mar 9, 2011

I have a user that runs a macro and it freezes when it tries to save a workbook to an FTP site. It appears to only happen to a certain user, because I can't duplicate it and other users are able to run the macro without issue (and the computers should be similar, same OS windows7 with excel 2007).

Code:

wbCSV.SaveAs strPATH_FTP & strCBD & ".csv", FileFormat:=xlCSV, CreateBackup:=False

wbCSV is declared as workbook
strPath_FTP points to a valid FTP location
strCBD is the file name, nothing special

is there anything i could try changing/testing to find out why it freezes this users computer and not others? I've step through the code and it definitely hangs on the saveas

thanks for any help.