[AccessD] Transferring Files via FTP

David Emerson newsgrps at dalyn.co.nz
Tue May 5 19:36:13 CDT 2020


Thanks.  So they are just for readability.  ret is the same as ret&

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
John Bodin
Sent: Wednesday, 6 May 2020 12:24 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transferring Files via FTP

shorthand for the types are: % -integer; & -long; @ -currency; # -double; !
-single; $ -string

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of David
Emerson
Sent: Tuesday, May 5, 2020 8:19 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Transferring Files via FTP

Thanks Stuart,

I am curious about the use of "&" at the end of one of your variables:

   Dim ret As Long
   
   ' Start the shelled application:
   ret& = CreateProcessA(0&, Pathname, 0&, 0&, 1&, NORMAL_PRIORITY_CLASS,
0&, 0&, start, proc)
   ' Wait for the shelled application to finish:
   ret& = WaitForSingleObject(proc.hProcess, INFINITE)
   ret& = CloseHandle(proc.hProcess)

What does the & do?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand




-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, 6 May 2020 11:42 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transferring Files via FTP

Heres' a  modFTP from an old application of mine which uses the built in
Windows FTP client and an FTP script generated "on the fly".  It will need
PTRSAFE, LONGPTR etc modifications for Officer 64bit.

(Code deleted to keep message size reasonable)

On 6 May 2020 at 11:07, David Emerson wrote:

> Hi Listers,
> 
> I hope everyone is keeping safe.
> 
> Can anyone give me recommendations for code/software so that I can log 
> into a secure FTP site using a username and password, and  upload and 
> download files via vba?
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list