I have a VB6 application that produces and prints .xls files thanks to an old and deprecated component. It isn't compatible with some of the new printers drivers (makes my application freeze and crash when a print occurs) , so I would like to find an alternative knowing that most PC where my application runs don't have Office installed.
I can't install "big" packages so I'm limited to the already-installed framework .Net 3.5. I can install pdfcreator or ExcelViewer though.
I'm looking for the cleanest way to implement it. I won't find anything native in VB6 so I'll just make an external call to something I've coded, so the technology used doesn't really matter.
I found only one solution for now and I consider it dirty : with an autoit script, I open Excelviewer and order it to print with autoit then close the file. It works but I'd like to find something more silent/user-friendly. I tried VBS but it is not supported by ExcelViewer. I found a .net 4.0 assembly GemBox but it's .net 4.0 (and expensive). I didn't manage to make my excel file a pdf to print the pdf with pdfcreator.
Any idea? Thanks