Command Line 1

[Curtis360it]

Is this how I would initiate the following from VBA?

Shell(copy /b filename \\servername\printername)

 

[longhair]

Curtis360it,
you can use the shell command or you can use the filesystemobject:

Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFile yourfile, "\\yourserver\yourfolder" & yourfile, True

the true at the end is to overwrite if it exists.
regards,
longhair

 

[Curtis360it]

I couldn't get my code to work. It says "File not found".

I am just trying to print the .prn file.

This doesn't work:
Shell ("COPY /B C:\Escript\output.prn \\Sheronc\HPDeskje")

But if I put the following in cmd then it works:
COPY /B C:\Escript\output.prn \\Sheronc\HPDeskje

 

[longhair]

Curtis360it,
try it with the filesystemobject.
for the shell command - i usually put the actual dos command into a variable then print then call the shell.
example:

x = "COPY /B C:\Escript\output.prn \\Sheronc\HPDeskje"
    Debug.Print x
    Call Shell(x, vbHide)

regards,
longhair

 

[Curtis360it]

Craziest freakin' thing- It still says "File not Found"...

Any ideas?

What's the command to just Print a .txt file in VBA?

 

[PHV]

Have you tried this ?
Shell ("CMD /C COPY /B C:\Escript\output.prn \\Sheronc\HPDeskje")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886