Visual Basic/feasibility

Advertisement


Question
Dear Vitaly,

I'm in the early stages of a project I hope to offer as a service or sell as an invention. Unfortunately, though the idea seems solid it's in an area I have very little experience of.

From the little I know, it seems possible that visual basic may be the software I need for the program (which I'll probably have to pay someone else to code for me).

I'm going to start with a long list of numbers (a few hundred thousand).

I then hope to divide them into manageable chunks, maybe ten thousand each, this stage being automatic.

I then want to feed each chunk into Excel, produce sum values at the end of each column and row, perform some other adjustments I can't talk about yet, and then remove the numbers (and the sum values) from the Excel workbooks and export those numbers, duly processed.

Is this the sort of thing that can be done with visual basic?
thanks,

Martin

Answer
Dear Martin,

Short answer is yes.

The question is Visual Basic the best tool for your project. Based on the specifics you provided this project best tool could be just database, something like Oracle.

But you provided very few details...

For example, you said: "I'm going to start with a long list of numbers (a few hundred thousand)." - but you are not telling where FROM are they coming?  And so on.


Regards,

Vitaly

Visual Basic

All Answers


Answers by Expert:


Ask Experts

Volunteer


VITALY

Expertise

Area of expertise is Visual Basic .NET (VS 2008 and Framework 3.5) design and development for Windows applications. You can ask me any Visual Basic questions and some questions about .NET Framework. You can also ask me how to use Component One controls in Visual Basic. Do not ask me questions about Web design and development in Visual Basic.

Experience

I'm working as VB programmer from 1997, so I have a lot of experience with Visual Basic .NET as well as Visual Basic 6. Area of expertise is Visual Basic .NET (VS 2008 and Framework 3.5) design and development for Windows applications; Component One controls for Visual Basic; User controls; Moving VB6 applications to .NET.

Education/Credentials
B.S. in Computer Science

©2016 About.com. All rights reserved.