[AccessD] Transferring Files via FTP

[John Bodin]

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