M
Mac Lingo
When I execute "Commands.Bat" (see below for content) in the CMD window,
the file "Commands.Out" is created in
"E:\Data - Mac\Mac's Documents\Application Data\".
But when I execute it from the Shell Command in Excel with
TS = Shell("Cmd /c Commands", vbNormalFocus)
the file "Commands.Out" is not created.
If I type "Cmd /c Commands" in the CMD window, it works.
Any ideas why this doesn't work in Excel?
Or is this just an error in my version of XP?
And if it is an error, how do I get around it?
tnx,
Mac
=============================================================================
Content of "Commands.Bat"
cd E:\Data - Mac\Mac's Documents\Application Data\
ftp -s:Commands.txt > Commands.Out
Content of "E:\Data - Mac\Mac's Documents\Application Data\Commands.txt:"
open FTP.Address
ftp_UserName
ftp_Password
Dir
bye
the file "Commands.Out" is created in
"E:\Data - Mac\Mac's Documents\Application Data\".
But when I execute it from the Shell Command in Excel with
TS = Shell("Cmd /c Commands", vbNormalFocus)
the file "Commands.Out" is not created.
If I type "Cmd /c Commands" in the CMD window, it works.
Any ideas why this doesn't work in Excel?
Or is this just an error in my version of XP?
And if it is an error, how do I get around it?
tnx,
Mac
=============================================================================
Content of "Commands.Bat"
cd E:\Data - Mac\Mac's Documents\Application Data\
ftp -s:Commands.txt > Commands.Out
Content of "E:\Data - Mac\Mac's Documents\Application Data\Commands.txt:"
open FTP.Address
ftp_UserName
ftp_Password
Dir
bye