- Joined
- 8/6/10
- Messages
- 283
- Points
- 38
I have a project I need to get done quickly, and any advice would be most appreciated.
To cut to the short of it: I need to write an app that will take Purchase Orders, tidy them up and dump them into Excel. The front-end needs to be accessible via an intranet to non-tech types.
I'm thinking I can use VB for this and create some form of web front end (I presume VB.Net) that communicates with Excel and inserts the data.
I'd normally just store all the data in a DB and spit out the Excel/CSV doc, but the XLS file has a bunch of work done it already to manipulate the data, so I need to integrate with this.
Any thoughts on the best approach? I've only ever used Excel as a basic spreadsheet and never done any coding in it so I'm new to this.
Thanks
To cut to the short of it: I need to write an app that will take Purchase Orders, tidy them up and dump them into Excel. The front-end needs to be accessible via an intranet to non-tech types.
I'm thinking I can use VB for this and create some form of web front end (I presume VB.Net) that communicates with Excel and inserts the data.
I'd normally just store all the data in a DB and spit out the Excel/CSV doc, but the XLS file has a bunch of work done it already to manipulate the data, so I need to integrate with this.
Any thoughts on the best approach? I've only ever used Excel as a basic spreadsheet and never done any coding in it so I'm new to this.
Thanks