Solved

MFC and VBA

Posted on 1997-10-22
7
565 Views
Last Modified: 2013-11-25
Hi! Can anyone recomend sample code or book to see how to implement VBA in MFC?
0
Comment
Question by:gelbert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 15

Expert Comment

by:Tommy Hui
ID: 1308630
0
 
LVL 8

Author Comment

by:gelbert
ID: 1308631
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
 

Expert Comment

by:gemme
ID: 1308632
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Author Comment

by:gelbert
ID: 1308633
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
 
LVL 8

Author Comment

by:gelbert
ID: 1308634
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
 

Accepted Solution

by:
gemme earned 100 total points
ID: 1308635
Thank you. I would be interested in any other information you come across that deals with this subject.
0
 
LVL 15

Expert Comment

by:Tommy Hui
ID: 1308636
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
java ^ examples 8 70
Message not shown 5 82
Input parameteres to DragOver 2 34
Where does legacy ASP.NET initialize language? 2 56
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question