Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Britain
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    (Re)logging in to FTP server (Office 2000)

    I am trying to automate a procedure that is run at regular intervals and, among plenty of other things, creates a Word document and saves it to an FTP server.

    OK so far: Document.SaveAs Filename:="ftp:..." does the job beautifully, provided I enter FTP user name and password the first time the procedure runs after Word is opened - and provided the "regular interval" is less than 15 minutes.

    Longer than this, and the Word SaveAs dialog box appears, pointing at a default directory on the local machine. However, break out of the procedure, go into debug mode and click the Continue button - and everything works perfectly.

    So presumably the connection to the server is being successfully re-established, but after the dialog box has been triggered - thus creating the need for the user intervention I very much want to avoid. Any ideas on how to get round this?

    Peter Wilkinson

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (Re)logging in to FTP server (Office 2000)

    You could break the operation into several steps:

    1) your code saves the document to a temp folder first,
    2) upload the document to the ftp server
    3) delete the temp file/folder if necessary

    This way, your users never see any dialog.

    See this post for a tip on how to send the file up (change the get to put in the example)
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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