Hi!
I was just trying to do the same, here is my code:
I got all the row's at one line, but the coloumns does not look so pretty.VB Code:
With lView For X = 1 To .ListItems.Count Printer.Print .ListItems(X).Text & " " & .ListItems(X).ListSubItems(1) & " " & .ListItems(X).ListSubItems(2) & " " & .ListItems(X).ListSubItems(3) & " " & .ListItems(X).ListSubItems(4) & " " & .ListItems(X).ListSubItems(5) & " " & .ListItems(X).ListSubItems(6) & " " & .ListItems(X).ListSubItems(7) & " " & .ListItems(X).ListSubItems(8) & " " & .ListItems(X).ListSubItems(9) Next X End With Printer.EndDoc
Hmm, why do i feel like my post is going to ruin the page width?![]()





Reply With Quote