[AccessD] Transferring Files via FTP

[Stuart McLachlan]

John's got it right. I hadn't noticed them :)

That  ShellWait would have been a a cut and paste from even older code elsewhere that 
used type indentifiers.


On 6 May 2020 at 0:24, John Bodin wrote:

> 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
>