Solved

MFC and VBA

Posted on 1997-10-22
7
587 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
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…

707 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