Click here to Skip to main content
15,886,873 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: FlowLayoutPanel1 and controls Pin
Ammar_Ahmad22-Jun-12 3:36
Ammar_Ahmad22-Jun-12 3:36 
GeneralRe: FlowLayoutPanel1 and controls Pin
Nick Otten22-Jun-12 3:42
Nick Otten22-Jun-12 3:42 
GeneralRe: FlowLayoutPanel1 and controls Pin
Ammar_Ahmad22-Jun-12 13:16
Ammar_Ahmad22-Jun-12 13:16 
QuestionCommandBuilder Problem Pin
Pasan14821-Jun-12 5:13
Pasan14821-Jun-12 5:13 
AnswerRe: CommandBuilder Problem Pin
David Mujica21-Jun-12 5:25
David Mujica21-Jun-12 5:25 
GeneralRe: CommandBuilder Problem Pin
Pasan14821-Jun-12 6:30
Pasan14821-Jun-12 6:30 
GeneralCommandBuilder is not preferred method Pin
David Mujica21-Jun-12 10:29
David Mujica21-Jun-12 10:29 
QuestionTrying to merge exel print jobs Pin
Nick Otten21-Jun-12 3:00
Nick Otten21-Jun-12 3:00 
Hello,

I'm struggeling with a bit of a problem. I got a program that prints production forms using excel. the problem is users are printing batches of 300 or more of these. The Xerox WC 3745 printer driver cant keep up with this and crashes.

I'm looking for a way to merge these printer tasks. i already try'd merging the work sheets into one workbook. this didnt work to well...excel doenst like to handle more then 250 worksheets it seems. also merging all data from the worksheets into one massive worksheet doesn't work (the layout cell count ect. are not the same)

anyone able to point me in a possible solution? perhaps i could catch the printer jobs and resend them as one big job? or is there a way that makes excel to do it that i just didnt find yet?

following code is looped to start the print jobs in the current version:
VB
If rbexact.Checked Then
            workbook.PrintOutEx(1, 3, 1, False, verbinding.printer(), False, Collate:=True)
        Else
            workbook.PrintOutEx(1, 3, 1, False, DefaultPrinterName(), False, Collate:=True)
        End If

AnswerBuild your own queue Pin
David Mujica21-Jun-12 3:31
David Mujica21-Jun-12 3:31 
GeneralRe: Build your own queue Pin
Nick Otten21-Jun-12 3:50
Nick Otten21-Jun-12 3:50 
AnswerRe: Trying to merge exel print jobs Pin
Dave Kreskowiak21-Jun-12 3:35
mveDave Kreskowiak21-Jun-12 3:35 
GeneralRe: Trying to merge exel print jobs Pin
Nick Otten21-Jun-12 3:44
Nick Otten21-Jun-12 3:44 
GeneralRe: Trying to merge exel print jobs Pin
Dave Kreskowiak21-Jun-12 4:04
mveDave Kreskowiak21-Jun-12 4:04 
GeneralRe: Trying to merge exel print jobs Pin
Nick Otten21-Jun-12 4:25
Nick Otten21-Jun-12 4:25 
GeneralRe: Trying to merge exel print jobs Pin
Dave Kreskowiak21-Jun-12 5:18
mveDave Kreskowiak21-Jun-12 5:18 
GeneralRe: Trying to merge exel print jobs Pin
Nick Otten21-Jun-12 21:26
Nick Otten21-Jun-12 21:26 
AnswerRe: Trying to merge exel print jobs Pin
Mycroft Holmes21-Jun-12 19:42
professionalMycroft Holmes21-Jun-12 19:42 
GeneralRe: Trying to merge exel print jobs Pin
Nick Otten21-Jun-12 21:32
Nick Otten21-Jun-12 21:32 
GeneralRe: Trying to merge exel print jobs Pin
Mycroft Holmes21-Jun-12 22:18
professionalMycroft Holmes21-Jun-12 22:18 
Questionbyte array to string Pin
jkirkerx20-Jun-12 18:06
professionaljkirkerx20-Jun-12 18:06 
SuggestionRe: byte array to string Pin
Sandeep Mewara20-Jun-12 19:36
mveSandeep Mewara20-Jun-12 19:36 
GeneralRe: byte array to string Pin
jkirkerx20-Jun-12 20:10
professionaljkirkerx20-Jun-12 20:10 
GeneralRe: byte array to string Pin
Sandeep Mewara21-Jun-12 19:17
mveSandeep Mewara21-Jun-12 19:17 
GeneralRe: byte array to string Pin
jkirkerx21-Jun-12 20:31
professionaljkirkerx21-Jun-12 20:31 
AnswerRe: byte array to string Pin
Nick Otten21-Jun-12 2:43
Nick Otten21-Jun-12 2:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.