How to use Excel to invoice

Recently, Excel has been used to set up invoices for users, allowing you to easily customize and adjust the set interval based on different invoices. The results are good. I would like to share my experience with you here.

 

Previously, VBA was rarely used, and there was no clue at the moment. Others recommended other tools, but they did not meet the requirements of users. Later, I found a <VBA code Daquan> on the Internet, which contains many sample codes. After learning it, I feel very beneficial. It was found that VBA is very powerful in implementing some functions. For example, you must print multiple details on one invoice, some print one invoice, some print the amount, and some do not apply the amount. In addition, you must be able to automatically calculate the total amount and convert it into a large write amount. In addition, it is required to be able to print continuously, and there is also a high requirement on the location. After all, it is a formal tax invoice, which is related to money. Everyone is very careful. These problems really took me a lot of effort, and I was able to help myself.

 

After the installation is complete, test it on the official printer. It feels really good. It seems that it will be a small case to try Excel again in the future.