script runtime in 2003

[Guest]

Hey all

I just moved from Access 2000 to 2003 and an application of mine doesn't work anymore. It's using VBA which is running vbscript which is running an ftp command. Any ideas on why? (Here's some code:

Dim o As Objec
Dim stSrcFile As Strin
Dim shortNamePath As Strin
Dim gu As New GeneralUtilitie
shortNamePath = gu.GetShortName(CurrentProject.Path
stSrcFile = shortNamePath & "aScrFile.scr
Set o = CreateObject("wscript.shell"
'Take the 0 off the statement below to see Dos windo
o.Run "ftp -s:" & stSrcFile, 0, Tru

thanks in advance
ari

 

[Albert D. Kallal]

Try creating the script in a simple stand alone text file. Use notepad to
create you file (test.txt).

Then simply type in:

Set o = CreateObject("wscript.shell")
o.Run "ftp -s:" & stSrcFile, 0, True

Now, re-name the text file with a .vbs extension. You can now run the
script...does it work?


Also, once you saved (or re-named) the text file..you can right click on it
to edit it...