I need to do some maintenance work for my family business’s invoicing software that was built with Visual Basic 6.0 during early 2000 and the database used is Microsoft Access 2003.
An Epson ESC/P2 compliant dot-matrix printer is used for printing the invoices. The invoicing program does not access the printer directly. Instead, it saves an invoice with the necessary ESC/P2 codes to a temporary text file and then executes the DOS command
I need to add a few tax fields due to the rollout of the Goods and Services Tax in India. As dot matrix printers are difficult to obtain these days, I’m thinking of updating this program with support for laser printers.
How can I print an MS Word template file with the required variables for the invoice directly from the program without having to open MS Word?
Note: The source code, database and invoice text file cannot be made public as it involves personal and confidential data of third parties.