im am trying to create a macro to upload a spreadsheet to an ftp site with a login nad password. I basically recorded a macro of saving to an ftp site that prompted me with a login and password. I also want the macro to not ask me what my login and password is everytime i run the macro. I jsut want it to upload as soon as i Run it. It did do the job while i was creating the macro but when i ran the macro after i created it, it didn't upload the file and gave me an error. Here is my code and my error. Any thoughts??
Run-time error '1004:'
Method 'Saveas' of object '_Workbook' Failed
Application.WindowState = xlMinimized
ChDir "C:\Documents and Settings\temp\Desktop\b_formats"
ActiveWorkbook.SaveAs Filename:="ftp://dlc.myftp.com/account.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _