Using VB 6 for a standalone spreadsheet app

kaikow · November 16th, 2002, 1:23 pm

Office 2000 and Office XP come with spreadsheet controls.Don't know how good they are, but they can only be used on systems licensed for Office 2000 or Office XP.What do folkes use for a stand-alone VB spreadsheet?

PinballWizard · November 16th, 2002, 2:05 pm

You'd have to use one of the VB grid controls and build the spreadsheet functionality you need - you may want to do a search on some of the VB magazine sites (e.g. Devx.com) - I've seen this sort of idea being used for tutorials several times. Also, there probably are commercial 3rd party controls out there which would provide what you need at a fraction of the cost of an Office licence.It really depends what spreadsheet functionality you need on your grid (e.g. user-directed formatting ? sorting ? math functions ?)P.

kaikow · November 16th, 2002, 5:40 pm

Thanx.I knew about the grid controls, but that's an awful way to go.

DominicConnor · November 17th, 2002, 4:08 pm

How much spreadsheet functionality do you need ?Is it just a grid, or full formulae etc ?

kaikow · November 17th, 2002, 4:39 pm

Not yet determined. Would be doing option pricing stuff, so largely formulas.IMHO, Excel is prevelant enough, I do not see the need to have a stand-alone app, but then it's not my decision.

lodette · November 18th, 2002, 2:10 pm

check out FormulaOne for an Excel compatible component in your VB project.

gotcpp · November 18th, 2002, 4:23 pm

have U heard about these guys: Stingrayrich in the functionality, but not free of annoying "features"

aspro · November 18th, 2002, 10:35 pm

You could build an ActiveX control of your own that incorporates a Grid, driven by a free database engine - then customise away. Easier and quicker just to buy a thrid party control like XGrid. You can purchase the source code too.