Dim oProcess As New System.Diagnostics.Process With oProcess.StartInfo .CreateNoWindow = True .WindowStyle = ProcessWindowStyle.Hidden .Verb = "print" .UseShellExecute = True .FileName = Application.StartupPath + "\tempcashDeposit.xlsx" End With xlWorkBook.Close(SaveChanges:=True) oProcess.Start() oProcess.Dispose() oProcess.Close()
For Each wsh As Worksheet in xlWorkBook.Worksheets wsh.PrintOut Next
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)