Solved

MFC and VBA

Posted on 1997-10-22
7
550 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
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dell Alienware Graphics Amplifier Driver for non-Alienware systems 18 351
Visual Studio: built-in keystroke automation 2 72
SSRS troubles 4 69
Why use this lambda? 12 37
Introduction: Displaying information on the statusbar.   Continuing from the third article about sudoku.   Open the project in visual studio. Status bar – let’s display the timestamp there.  We need to get the timestamp from the document s…
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…
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…

829 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