Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert VBA to VB?

Status
Not open for further replies.

Hondy

Technical User
Mar 3, 2003
864
GB
Hello

Maybe a simple one, maybe not. I want to create an exe to duplicate the functions currently used by an Excel based VBA application. How do I convert it to a stand alone application - I was thinking to use Visual Studio Express 2008? Do I need to convert it? Any pointers?

Cheers

 
Hi,

Just export the module(s) containing your UDFs and import into Visual Studio.

If your functions reference objects, you must add those object library references AND you must CREATE those objects in your functions and reference them where used.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top