VBScript

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
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?
Click to expand...

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
 
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
 
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?
Click to expand...

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