Integrate VBA to my aplication

[HMPA]

Hello all,
How can I integrate a VBA tecnology to my VB6 project, as ACCESS or WORD do.

I want something as Visual Basic for Applications 6.3 SDK, but free.

[WorkHorse]

Without going through Microsoft I very much doubt you could get anything like VBA, much less for free. Many applications use macro languages, some are similar to VBSrcipt. I don't know of any macro language components to add to VB applications, but if you want something free, try looking around the Internet for freeware macro languages. You won't get VBA, but you might find some fairly cheap "VB-like" macro languages that would let your users customize your app.

[HMPA]

thanks WorkHorse

[alex_read]

You either need to install the VBA SDK, or have Microsoft Office installed on the computer to develop it properly - to have the intellisense properties and methods listed, gain access to the help files on specific VBA calls and test the application when it calls out to an office application.

Having said that, if you're a genius & know all of the VBA commands to use, their arguments & don't need/want to test your code, you can write a vb app & compile it to run on a machine with office instaled by using early binding - or calling the createobject method:

Dim objXLApp As Object
Set objXLApp = CreateObject("Excel.Application")
 
objXLApp.workbooks.....

etc. Just replace the word Excel above for either Word, PowerPoint, Access, or I think Binder depending upon the office application you want to work with.

[alex_read]

Okay just had a side thought on that - all of the Microsoft help files are online & you can find all of the samples,calls & arguments of VBA at the following MSDN Office Developer site:

http://msdn.microsoft.com/library/de...entid=28000550

[HMPA]

that's right alex_read,
but I need to make aplication at runtime, using vba.
with the OLE way I can't intepret code... or make vba aplication using a framework.