Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MFC and VBA

Posted on 1997-10-22
7
Medium Priority
?
627 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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…

636 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