[log in to unmask] (Peter Chong) wrote in message news:<[log in to unmask]>...
> Raymond Familar <[log in to unmask]> wrote in message news:<[log in to unmask]>...
> > I have used Reflection to "record" ftp actions and create a script that
> > will login (prompting for userid/password), and pass the file.  Some else
> > mentioned how to get ftp from Excel.
>
> Link Excel to MS Access and add this routine in the Access VBA
> http://www.mvps.org/access/modules/mdl0015.htm
>
> Peter Chong
> Sr. ERP Analyst VB/Oracle

I found another example of VBA code.

Sub Ftp()
Open "C:\Temp\temp.tmp" For Output As #1
Close #1
'''Construct the batch file
Open "C:\Temp\ftpfile.bat" For Output As #2
    Print #2, "ftp -n -s:C:\Temp\ftpfile.txt"
    Print #2, "@echo y| del C:\Temp\temp.tmp"
    Print #2, "Exit"
Close #2
'''Contruct the FTP instruction file
Open "C:\Temp\ftpfile.txt" For Output As #3
    Print #3, "open SERVER"
    Print #3, "user USERNAME"
    Print #3, "PASSWORD"
    Print #3, "get //BLAH/file.fil"
    Print #3, "close"
    Print #3, "bye"   '''Switches back to dos shell
Close #3
'''Run the batch file, hidden
Call Shell("C:\Temp\ftpfile.bat", vbHide)
Do
Loop While Dir("C:\Temp\temp.tmp") <> ""
Kill "c:\Temp\ftpfile.bat"
Kill "c:\Temp\ftpfile.txt"
MsgBox "Complete!"
End Sub


Peter Chong
Sr. ERP Analyst VB/Oracle

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *