[AccessD] Transferring Files via FTP

[David Emerson]

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