Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Reload this Page Excell/VBA AddinInstall event
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA 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
 
Old July 22nd, 2005, 06:05 AM
Registered User
  
Join Date: Jul 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excell/VBA AddinInstall event
The Application event

AppEvents_WorkbookAddinInstall(ByVal Wb As Workbook)

has one argument WB, which returns the current open workbook.

When the user uses Tools>Addins to install an addin I need to identify which addin has just been installed. I would be grateful if anyone could tell me how.

Mike House
 
Old July 22nd, 2005, 06:27 AM
Registered User
  
Join Date: Jul 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Sorry, bad diagnostics, WB is the installed addin.

Quote:
quote:Originally posted by BrighterLater
 The Application event

AppEvents_WorkbookAddinInstall(ByVal Wb As Workbook)

has one argument WB, which returns the current open workbook.

When the user uses Tools>Addins to install an addin I need to identify which addin has just been installed. I would be grateful if anyone could tell me how.

Mike House
Mike House





Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Event Repeat in Excel VBA ? plz help poorheler Excel VBA 1 July 4th, 2007 06:37 AM
Using Excell Funtion in VBA coolrks BOOK: Excel 2003 VBA Programmer's Reference 1 February 8th, 2006 11:26 AM
KeyPress Event in VB different from VBA PaulG Beginning VB 6 3 February 3rd, 2004 01:31 PM
event coding - Access VBA bph Access VBA 5 January 6th, 2004 12:17 PM
Click Event for VBA listbox Blade Beginning VB 6 1 June 11th, 2003 09:17 AM




Contact Us - Wrox - Privacy Statement - Top

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