I need a spreadsheet based sales order code in VB.

Asked By 0 points N/A Posted on -
qa-featured

I am using OpenOffice spreadsheet for all my financial records keeping. I was wondering if it is possible to have a spreadsheet based sales order capable of throwing an email whenever there is a new order? I would like it integrated in such a way that I do not have to design and then send the email separately. A code in Visual Basic I guess?

SHARE
Answered By 45 points N/A #164307

I need a spreadsheet based sales order code in VB.

qa-featured

Hello Carlson,

It looks like you are looking for a spreadsheet based sales order programmed with Visual Basic. MS Excel includes Visual Basic for Applications which can be utilized by using macros or programs in Excel. 

A macro can be created to perform one or more functions like copy, paste or inserting rows or columns. In the excel developer menu you will find the record macro facility which you could use to create a macro based on your need. You can create a macro for copying email address and send a mail to that address.

I hope this helps.

Related Questions