Excel to Vb

[jamielill]

if you have an Excel vba program is there any way to run this as a stand alone vb program

jamie

 

[Rekd]

if you have an Excel vba program is there any way to run this as a stand alone vb program

jamie

In a word, yes. But it's not a built-in function. I've taken a couple of my macros and made .exe's and scripts with them.

The VBA functionality will be there, but the excel specific stuff will not. What is it you're trying to create? This is not a simple yes or no type of questions.

 

[Derek Brown]

I write the code in Excel VBA and then call that code from a Visual Basic .exe file.
By doing that I can then easily automate Access, Word, PowerPoint and MapPoint through Excel VBA - it is sometimes difficult to do that directly from vb, particularly Access.