Unanswered: Printing contents of an array with VBA
Is there any way that I can print the contents of an array direct to a printer with VBA? The array is created as errors are found in updating the spreadsheet from an Oracle database so that they can be saved to a text file, shown in an error viewer or printed.
I can easily give the user the ability to print a text file from the array, or show them in an error viewing dialog box, but I can't see a way of printing directly to the printer.
Does anyone know how to do this? I thought about using Windows API calls, but I have never used any for printing before. I don't want to have to put the data in a worksheet or anything like that if I can help it, as I don't want to add worksheets to the workbook, even temporarily.
I'd appreciate any help that anyone can give to me.
Make something idiot proof and someone will make a better idiot...