sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 574
- Office Version
- 365
- Platform
- Windows
I realize this is only a start, but I need to be able to shell out and open a file with the name "Test.jpg" and print it out while ensuring that it will print on the width of a single sheet of paper in portrait orientation. I see a lot of code with send keys, but none of that worked for me when I tried it and figured there must be something much simpler to do here. Any help would be much appreciated. Thanks, SS
VBA Code:
Private Sub cmdPrintJobStatus_Click()
VBA.Shell "EXPLORER.EXE \\SomeFolder\PROJECTS\Test.jpg", vbNormalFocus
End Sub