Adding VBA facility to apps.

Hi,

I would like to know how to enable a VB5 application to receive VBA commands and execute them (like Excel, Access etc.) The idea is that the app will be a sort of container for different purpose controls which will configurable throught VBA coding from the end user. An exmple would be very helpful!

Thank you for your help!

SashaB
SashaBAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
I don't know if this is a concern for you but you to pay for it.

See Microsoft Web site regarding this subject at: http://msdn.microsoft.com/vba/corpdev/default.asp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
troywillmotCommented:
I'm not sure where you can get it from now, but the last VBPJ (I think) magazine had an attached brochure that talked about VBA. Included with the brochure was a CD with a Wizard that automatically modified your code and integrated VBA with your program automatically.

Afterwards of course, you can manually change anything you like.

It looked like the cool way of doing it. If I can find my copy of the CD I'll let you know if there's a download site for it. You could try searching Microsoft of www.windx.com though.
0
troywillmotCommented:
If you follow the link emoreau
 provided, there is a link on that page to the VBA SDK, I think thats what my CD has on it, so its probably what you want.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

SashaBAuthor Commented:
Thank you so much,

it is what I was looking for! The problem is that I'm still using VB5 (SP3) you know if the same is possible with this version? The articles I've found are using VB6 as requirement. Otherwise is there any other language that I can use in replace of  VBA?

Thanks,

SashaB
0
Éric MoreauSenior .Net ConsultantCommented:
Move to VB6. It will be a lot easier for you to include VBA than any other thing. Everybody is moving to VBA (even Word Perfect!!!).

I don't know any other products that can be implemented within an application that offers what VBA can!
0
SashaBAuthor Commented:
I know I know...

It will be a lot lot easier to pass to VB6, unfortunately I can't right now. The standard that we use in the office is VB5 SP3 and I have to find a way to develop the idea I had in this environment if it is possible. Any suggestions?

Thank you
0
Éric MoreauSenior .Net ConsultantCommented:
There are times when you have to say the user or the manager: "If you want this functionnality, we have to upgrade".

Isn't it a great oppurtunity for you to updrage?
0
SashaBAuthor Commented:
I like your philosophy... I'm afraid they will not love it as well! It is woth a try anyway...
Are you definetelly positive that it could not be done in any other way?
Thanks
0
Éric MoreauSenior .Net ConsultantCommented:
VBA was existing during the VB5 era. Maybe can you ask Microsoft if this version is still available!
0
troywillmotCommented:
Sure, or you could try getting an evaluation/control creation edition of VB 6, load your project and run the Add-In, have it modify your code and then convert it back to VB5.

Alternatively, you could run the wizard on a test PC with VB 6, look at the code it produces and replicate it.

I suspsect that the only reason VB 6 is listed is because the Add-In wizard is a VB 6 addin only. If thats the case, then the code it produces should still function fine, you just need it as an example to work off.

Lastly, you could get someone else you know, or on this list, to run it on a similar test project for you and send you the code.

Also, did you happen to see how much it cost to license VBA ? Someone told me it was around $50K.
0
SashaBAuthor Commented:
All,

sorry I was out of the country fro a while.... I would like to thank everybody for your help, you really answered my question. Unfortunately Microsoft still "Microsoft" :(  and I will leave my ideas to another time (VB6 upgrade). I accepted emoreau comment as an answer, I will not give an higher grade just because it was not a personal "brainstorm" but a VERY HELPFUL reference to a link.

Thank you again and read you at the next question

Sasha
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.