Use VB Script to generate invoices in Excel format automatically
This post is probably the most testing post I have ever done on this site so I'm keeping my fingers crossed that there is someone with the knowledge that can help. (please)
Right If I start with my requirement:
I have a very simple excel spread sheet that I would like to achieve the following:
1. Create quarterly invoices automatically in a separate excel spread sheet that are saved to the right customer directory.
2. Print the newly created invoices automatically (2 copies of each) quarterly (not sure if this would be done via a scheduled task)
3. There are 2 different invoices a)management fee b)company secretary fee. Each will be a different invoice however no all companies have the company secretary invoice.
I have attached a copy of the data source template and a copy of the template for the invoice.
I will be completely honest I know absolutely zero where it comes to VB scripts and Zero where it comes to excel macros and how they work. It may be a case that another technology would be better but hey I guess that's why I'm asking the question. Merlin-Management-fees.xlsx
VB ScriptMicrosoft Excel
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.