Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.basic.visual.misc > #1710

Re: visual studio controls

From GS <gs@somewhere.net>
Newsgroups comp.lang.basic.visual.misc
Subject Re: visual studio controls
Date 2013-02-20 22:46 -0500
Organization A noiseless patient Spider
Message-ID <kg4587$3b6$1@dont-email.me> (permalink)
References <5a40821d-c570-4845-9294-8304b8da6abe@googlegroups.com>

Show all headers | View raw


colmkav explained on 20/02/2013 :
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as 
> the user interface. I want to replace the interface with a VB.net project 
> using VB.net controls instead. which would be the best control to use in my 
> application?
>
> My current spreadsheet has a start button and a list of jobs with a check box 
> for each specifying whether the job is to be run or not.

You could use a 3rd party spreadsheet control if you need spreadsheet 
features/functionality. If not then a grid control as _Auric suggests.

I bought Farpoint's Spread.ocx ActiveX control back when MS released 
the Ribbon so I could make all my Excel-based apps standalone Windows 
apps using VB6. It works great! (Farpoint is now GrapeCity, and they do 
have a dotnet version of the control. It's not cheap!!)

In addition to Karl's comment, I can't imagine why you'd want to go 
with dotnet if you're already familiar with VBA since dotnet's an 
entirely different language (despite name similarities). VB6 is as 
close as you'll get to VBA, and most all of the code is portable beteen 
the two!

I went back to Excel-based apps because that's what clients wanted 
(popularity rules in the corporate world), so I've settled on combining 
VB6 and Excel via automation. I still use my Spread.ocx for proprietary 
projects, though.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to comp.lang.basic.visual.misc | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-20 14:52 -0800
  Re: visual studio controls Karl E. Peterson <karl@exmvps.org> - 2013-02-20 15:21 -0800
  Re: visual studio controls "Auric__" <not.my.real@email.address> - 2013-02-21 01:23 +0000
  Re: visual studio controls GS <gs@somewhere.net> - 2013-02-20 22:46 -0500
  Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 01:17 -0800
  Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 01:20 -0800
  Re: visual studio controls Deanna Earley <dee.earley@icode.co.uk> - 2013-02-21 09:28 +0000
    Re: visual studio controls GS <gs@somewhere.net> - 2013-02-21 13:07 -0500
  Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 11:10 -0800
    Re: visual studio controls GS <gs@somewhere.net> - 2013-02-21 14:22 -0500
    Re: visual studio controls ralph <nt_consulting@yahoo.com> - 2013-02-21 13:43 -0600
    Re: visual studio controls "DaveO" <djo@dial.pipex.com> - 2013-02-22 09:55 +0000

csiph-web