I've been trying to find a solution for this with repeated failure.
The goal is to copy a PRN file to a network printer. I decided to use the Shell() command to accomplish this. The problem is that I can bring up the Dos command line but, the dos command is not executed. Am I just not understanding the usage of Shell() ?
Here is my code so far:
Expand|Select|Wrap|Line Numbers
- Private Sub cmd_invoice_Click()
- Dim Pal_location As String
- Dim dos_command as String
- Pal_location = "X:\Stage\PRN Test Files\order_INV.prn"
- dos_command = "copy /c " & Pal_location & " \\server\printer"
- Shell ("CMD.EXE " & dos_command & "")
- End Sub
Bender