VBA call shell doesn work

January 10, 2010 at 06:38:27
Specs: Windows XP, 128
this appear the cmd window, but not given result

Call Shell("command.com /c type c:\tekst1.txt > test.txt", 1)

need to write into test.txt all info exist in tekst1.txt


See More: VBA call shell doesn work

Report •


#1
January 10, 2010 at 14:45:51
i think you just need to remove the "Call" from you line:
Call Shell("command.com /c type c:\tekst1.txt > test.txt", 1)

make it:
Shell("command.com /c type c:\tekst1.txt > test.txt", 1)



Report •

#2
January 10, 2010 at 17:13:33
Question: Why are you not using FileSystemObject's CopyFile method?

Report •

Related Solutions


Ask Question