Excel to VBA

[Guest]

If I wanted to make my spreadsheet a stand alone program by recreating it in
VBA but would be lost in trying to do so, are there people out there I can
hire to do the conversion?
Any references?

 

[Tim Williams]

Do you mean recreating it in VB ? You cannot produce a standalone program
in VBA - you still need to run it in Excel/Word etc.

Tim.

 

[Myrna Larson]

VBA works from within an application, in this case Excel. To eliminate the
need for Excel you could write your code in VISUAL BASIC proper, using a grid
control. I have no idea what the grid offers in terms of functions. You might
well end up having to write code to replicate the Excel functions you are
using in your formulas.

 

[ross]

To make a stand alone programe you would need VB poper (or another
fully compileable langue)- I would not think this is a good idea, why
would you want to do this.

What about making you spread sheet into an addin (which is kind of
like a stand alone programe, in fact if you reallt like you can hide
the excel window and use you own interface - but that kinda misses the
point.

There are 1000s of folks who do this, there are a lot in this
newsgroup.

Take alook around the net, and see if you can find someone you like
the look of.

Good luck
ross

 

[Tom Ogilvy]

I haven't, but I have observed some related discussions. (You might want to
search google for this newsgroup with seach terms like copyright and author
Pearson).
I think you just need to mark it as copyrighted. You would then need to
establish some means to prove when it was created and so forth such as a
dated copy of the original file and witnesses would not hurt.

As to ownership of the work, you should meet with your new employer and
establish up front ownership of the property. Some companies see such work
as competitive and won't allow it, so you might want to make inquiries
first.

 

[Myrna Larson]

Maybe

Application.Visible = False

Yes VB proper is what i meant sorry. The idea of hiding
the excel window and use you own interface sounds interesting, is there a
simple way to hide the excel window?