FTP via Access 2000 VBA shell
Posted on 2006-04-04
I would like to import multiple files into a specific directory via ftp by executing an ftp script file inside VBA code.
So I created a script file named A2006D.TXT:
QUOTE SITE FILETYPE=JES
lcd W:\PerformanceMeasures\Monthly Reports
Then I created a batch file named A2006E.BAT:
cd W:\PerformanceMeasures\Monthly Reports
If I run A2006E.BAT from command line, it executes fine.
But if I run it through shell, it fails.
Dim cmdline As String
cmdline = CurrentProject.Path & "\A2006E.BAT"
Shell cmdline, vbMaximizedFocus
What is wrong with my code? Can you help me?