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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Éric MoreauConnect With a Mentor Senior .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
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.