I need a spreadsheet based sales order code in VB.

Asked By carlson devorett 0 points N/A Posted on - 04/21/2013

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?

• Status: Open
• Question Views: 673
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Michael B Rodgers 45 points N/A #164307

I need a spreadsheet based sales order code in VB.

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.

About Michael B Rodgers

Questions
22

Answers
105

Best Answers
41

• Vote Up 0 Vote Down

• Posted on - 06/02/2013
• Question Category: Visual basic