Moving from Excel to Visual Studio

[Roger on Excel]

In Excel, I use forms alot.

I now have a form based spreadsheet which i am considering moving into
visual studio to create a standalone application. This will take alot of
time, however I know I can export the forms into visual studio so that the
interface looks the same

However, my problem is getting my head around storing data/numbers in that
environment and then working with equations to deliver results and then acces
and store those numbers.

For example its easy in excel to reference particular cells on particular
sheets to access and deposit data/formulas/values and then excel does the
number crunching.

Can someone give me some pointers about how this is handled with vba outside
of excel - presumably one can use a database to store data and then access
particular row/column addresses, but what about formula calculations?

Can anyone give me some pointers as I consider this transition from Excel VBA

Many Thanks,

Roger

 

[Bob Phillips]

Why would you use the existing forms when Visual Studio gives you a far
richer forms capability.

Using Visual Studio is similar to using any form of automation. You connect
to an instance of Excel, either existing or new, open or add a workbook,
then access ranges in a nominated sheet. Once you have navigated through the
object hierarchy, it is just like coding in VBA.

But of course, Visual Studio requires far more setting up than VBA, all of
the interop stuff etc.

HTH

Bob

 

[RB Smissaert]

What is the reason you want to make a stand-alone application?
What are you moving your code to? VB6?
Are you sure you can move the forms to Visual Studio? I thought there
were problems with that.
Doing the formula's may be a problem and it might be that you will still
need
Excel to do that.

RBS

 

[Roger on Excel]

Hi Bob,

So do you think its possible to use an excel file as a data source, even if
excel is not installed on a users pc?

Roger