troubleshooting Question

Use VB Script to generate invoices in Excel format automatically

Avatar of cybersi
cybersiFlag for United Kingdom of Great Britain and Northern Ireland asked on
VB ScriptMicrosoft Excel
32 Comments1 Solution1182 ViewsLast Modified:
Hi All

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.
Join our community to see this answer!
Unlock 1 Answer and 32 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 32 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros