Using a "SHELL" Command

[Mac Lingo]

I'm getting an error message that implies that I can't call a procedure on
my system:
"This error can also occur if an attempt is made to call a procedure that
isn't valid on the current platform."
I'm running VBA 2003.

And the procedure I'm trying to run is to invoke a batch file ith the line

TS = Shell(FileName & ".bat", vbMinimizedNoFocus)

Any idea why this isn't working???

Mac in Berkeley, CA

 

[Tom Ogilvy]

You need to supply the full path to the file?

 

[Mac Lingo]

Re Tom Olg's note, the file directory is specified.

But I thought it might be useful to show the batch file:

ftp -s:E:\Data - Mac\Mac's Documents\My Stuff\Programs\Directory.txt
Echo "Complete" > E:\Data - Mac\Mac's Documents\My
Stuff\Programs\Directory.out

And Directory.txt:
open FTP....
username
password
cd ...\Mac's\
binary
send E:\Data - Mac\Mac's Documents\My Stuff\Programs\Directory.txt
Diretory.txt
bye

 

[Guest]

Could it have anything to do with the typo in the 2nd to last line?

 

[Mac Lingo]

The last line has been fixed as follows.

to
send E:\Data - Mac\Mac's Documents\My Stuff\Programs\Directory.txt
Directory.txt

Doesn't fix it.

 

[gimme_this_gimme_that]

You ftp script is a joke.

Put the following in a file having a suffix .scr, for example,
example.scr.
Use forward slashes not backslashes
Use put not send
"lcd" means "local cd"
Use \ to escape blanks

user username password
bi
cd /Mac's
lcd E:/Data\ -\ Mac/Mac's\ Documents/My\ Stuff/Programs
put "Directory.txt"
quit

Get your ftp script running on the command line. After that change
your VBA to:

TS = Shell("ftp -s hostname example.scr", vbMinimizedNoFocus)

 

[Mac Lingo]

Can "SHELL" execute a Batch Command.

And once the command is executed, how do I get the results of running the
FTP command back to me?

Mac

 

[Guest]

The batch file DOES work if you double-click it right?

 

[Mac Lingo]

The batch file DOES work if you double-click it right?

 

[Craig Coope]

I assume it means "if you double click the mouse button properly" on
it.

 

[JE McGimpsey]

I assume a comma is missing:

The batch file DOES work if you double-click it, right?