Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    113

    Unanswered: saving to ftp site macro

    hey guys,
    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

    Sub FTPupload()

    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:="", _
    ReadOnlyRecommended:=False, CreateBackup:=False
    End Sub
    Last edited by inho78; 12-08-04 at 20:52.

  2. #2
    Join Date
    Nov 2004
    Posts
    108
    I have Secure FX and I just send command lines to the secureFX to place, delete or save info

    Do you have an FTP application?
    to err is human ; to really mess things up requires a computer

  3. #3
    Join Date
    Sep 2004
    Posts
    113
    is there an ftp program i can download that can upload files from my desktop to the ftp site?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •