VBScript

[George]

Currently, in an Access VBA module, I Shell to DOS to
execute some ftp requests.
Yesterday I learned that one can use VBScript instead of
DOS. This would permit me to specify universal naming
convention, and long directory names, and other advantages.

When I have learned VBScript, can I Shell to a .vbs file
using Access VBA in the same way that I now do in DOS?
Or is there a better way?

Thank you in advance for your help
George

 

[Dev Ashish]

When I have learned VBScript, can I Shell to a .vbs file
using Access VBA in the same way that I now do in DOS?

Yes you can. You may have to provide the path to the compiler (cscript.exe
or wscript.exe). Another option would to create a batch file that calls the
vbscript file and shell to the batch file instead.

-- Dev

 

[George]

I think I have to do this "at all", don't I.
There's no way to, for example, invoke ftp from within
Access VBA, is there?

George

 

[Tim Ferguson]

When I have learned VBScript, can I Shell to a .vbs file
using Access VBA in the same way that I now do in DOS?
Or is there a better way?

Surely there is nothing you can do in VBS that you cannot do in VBA
(although there is plenty the other way round)? Would it not be easier just
to do the whole lot within the Access platform?

Tim F

 

[Dev Ashish]

There's no way to, for example, invoke ftp from within
Access VBA, is there?

If you mean as a VBA provided facility, then no... However, you can
certainly use FTP functionality by either shelling to a script file or
using the WinInet APIs directly.

[ http://www.mvps.org/access/modules/mdl0015.htm ]
[ http://www.mvps.org/access/modules/mdl0037.htm ]
[ http://www.mvps.org/access/downloads/InternetTransferLib.zip ]

-- Dev