MFC and VBA

Hi! Can anyone recomend sample code or book to see how to implement VBA in MFC?
LVL 8
gelbertAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Tommy HuiEngineerCommented:
0
gelbertAuthor Commented:
Thanks for advice. It is great sample how to use VBScript but I am looking for VBA(Visual Basic for Applications) samples. Sorry but I have to reject. I will wait about a week or two and if no one post anything better then I will award you points
0
gemmeCommented:
I am involved in a project doing just what you asked.   I have got a great deal of information from "Inside Visual C++" by David j. Kurglinski.  I have the older version that deals with version 4.0 but it still gave good example of creating OLE automation servers and controllers from VBA inside Excel in chapter 23.  If you know how to add automation to a project after creating it with app wizard without automation, let me know.

Good luck
0
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

gelbertAuthor Commented:
Thanks for answer but I am looking for good sample of MFC application which in INTEGRATING VBA into itself that means I am looking for app which supports all interfaces which you have to support like IVBA and other.
  If you need insert Autmation in your app then just create new application which support Automation with Wizard and cut and paste code. I do it this way.
  By the way company called SummitSoft which is official VBA agent for Microsoft is selling VBfx ( wizard + library) to attach VBA to MFC but you have staticly link your app to library size of 5.8 MB (in debug). So I am looking for way how to use OLE interfaces directly to integrate VBA.
0
gelbertAuthor Commented:
Thui, I am ready tp award you 100 points for your answer. It did not answer my question but anyway I liked sample. Just post something as an answer and I would accept it.
0
gemmeCommented:
Thank you. I would be interested in any other information you come across that deals with this subject.
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
Tommy HuiEngineerCommented:
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
Microsoft Development

From novice to tech pro — start learning today.