Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming
Hello,
I want to use MS Excel for invoicing our customers and I can not figure out how. I need a macro to open three files 1 - Customer database 2 - Services database 3 - Invoicing template, Then another macro will find customer number in services database then look for that customer's details in customers database and copy data from both databases to invoice template then after all the calculations it will print invoice. This process will be continued until all the services provided in a month are invoiced and printed in PDF and emailed to indivudual customers. I know what to do but i don't know how to do it, is there anyone who can help me with this? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming
On Oct 15, 8:19 am, Immaculate wrote:
Hello, I want to use MS Excel for invoicing our customers and I can not figure out how. I need a macro to open three files 1 - Customer database 2 - Services database 3 - Invoicing template, Then another macro will find customer number in services database then look for that customer's details in customers database and copy data from both databases to invoice template then after all the calculations it will print invoice. This process will be continued until all the services provided in a month are invoiced and printed in PDF and emailed to indivudual customers. I know what to do but i don't know how to do it, is there anyone who can help me with this? Many thanks Hello Immaculate, You are asking a lot for free. I don't think you will find any takers to do a such a project for nothing. You would be better off hiring someone to develop, and implement this project for you. Search for Excel VBA programmers. There a quite a few sites that offer experts for hire. I am sure you can track someone down that is close by where you live. Sincerely, Leith Ross |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming
On Oct 15, 5:27 pm, Leith Ross wrote:
On Oct 15, 8:19 am, Immaculate wrote: Hello, I want to use MS Excel for invoicing our customers and I can not figure out how. I need a macro to open three files 1 - Customer database 2 - Services database 3 - Invoicing template, Then another macro will find customer number in services database then look for that customer's details in customers database and copy data from both databases to invoice template then after all the calculations it will print invoice. This process will be continued until all the services provided in a month are invoiced and printed in PDF and emailed to indivudual customers. I know what to do but i don't know how to do it, is there anyone who can help me with this? Many thanks Hello Immaculate, You are asking a lot for free. I don't think you will find any takers to do a such a project for nothing. You would be better off hiring someone to develop, and implement this project for you. Search for Excel VBA programmers. There a quite a few sites that offer experts for hire. I am sure you can track someone down that is close by where you live. Sincerely, Leith Ross- Hide quoted text - - Show quoted text - Hi Leith, I agree with your suggestion, but i need to exercise my brain. We can pay someone but i need to share programming idea. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel programming | Excel Programming | |||
Excel API programming | Excel Programming | |||
Excel Vba Programming | Excel Programming | |||
Excel Programming | Excel Programming | |||
Excel programming using VBA | Excel Programming |