Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2
This is the forum to discuss the Wrox book Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander; ISBN: 9780470046432
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 6th, 2009, 09:56 AM
Registered User
 
Join Date: Apr 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile Chapter 18: Automation Add-Ins and COM Add-Ins

I think this is a great book so far, but I just got completely lost on this chapter! For some reason, I seem to be unable to find some of the commands under the 'File' menu, for example, to create a new ActiveX dll. project. Am I missing something obvious? I would really appreciate it if anyone could help me out here, because all the code seems to work fine, I just can't compile it!

Thanks,
David

Last edited by David Bibby; April 10th, 2009 at 05:39 AM..
  #2 (permalink)  
Old April 10th, 2009, 05:47 AM
Registered User
 
Join Date: Apr 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile I think I've got it now...

I think I have now worked out the answer to my own question, you need to have VB6 installed in order to run the code in this chapter. Unfortunately you can't get the original VB6 anymore; I think the options are to find a second hand version, or to upgrade to the Microsoft Visual Basic NET platform - which would require learning a whole new set of procedures. Pity, it would have been nice to work with some COM Add-Ins for a change!
David


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add Push button or Check Box in outlook add-ins capdevs VS.NET 2002/2003 0 January 7th, 2006 08:51 AM
VBE Add-ins crmpicco Excel VBA 0 May 11th, 2005 06:59 AM
Add-Ins jacemiles BOOK: Beginning Access VBA 0 February 2nd, 2004 12:40 PM
Modules and Add Ins jake Excel VBA 0 November 21st, 2003 08:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.