Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13788

Re: FTP a file(s) using MS Access

From PW <PW@noemailaddress.com>
Newsgroups comp.databases.ms-access
Subject Re: FTP a file(s) using MS Access
Message-ID <7nrfneh73jq4e7lbssp2dfmdn08ocoh2ia@4ax.com> (permalink)
References <3efumeh5gvsg3623o260u00uaeode4r4vo@4ax.com> <9bv0nelq4888nevf5r5ds2n56qslt6sbgb@4ax.com> <c434eed5-e779-4308-9333-23950a817a22@googlegroups.com> <9j45ne9esfn6ccprsjsjijs48avk9hktl2@4ax.com> <6a6c99be-2fae-44f1-8ec5-a331ad53ab39@googlegroups.com>
Organization Forte - www.forteinc.com
Date 2019-09-10 11:44 -0700

Show all headers | View raw

>> Hi Ron,
>> 
>> I put the only code that was not commented out behind a button and it
>> did not look like it did anything:
>> 
>> 
>> Dim stSysDir As String
>>     stSysDir = Environ$("COMSPEC")
>>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
>>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
>> End Sub
>> 
>> -paul
>
>The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 


*---

I do not know how to create a script file!

-paulw

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-03 21:32 -0700
  FTP a file(s) using MS Access Mal Reeve <mal.reeve@gmail.com> - 2019-09-04 04:18 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 10:10 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:18 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:22 -0700
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 20:14 -0700
    Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-05 04:55 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:08 -0700
        Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-09 05:33 -0700
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-10 11:44 -0700
            Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-10 12:38 -0700
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-11 15:33 -0700
                Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-12 06:04 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 14:39 -0700
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-16 12:03 -0600
  Re: FTP a file(s) using MS Access samxjones2@gmail.com - 2019-09-05 06:11 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:46 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:57 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 12:06 -0700
      Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-08 12:35 -0700
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-08 21:03 -0700
  Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 10:55 -0400
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 13:38 -0700
      Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 15:49 -0400
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:00 -0700
          Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-08 16:05 -0400
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 10:47 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 11:16 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-14 12:02 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:04 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:31 -0600
    Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-23 12:37 -0400
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 17:28 -0600
        Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-23 17:56 -0700
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 20:47 -0600
        Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-24 08:47 -0400
          Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-24 13:55 -0400
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 16:24 -0600
              Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-25 09:57 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 17:18 -0600
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 15:29 -0600
  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 15:58 -0600

csiph-web