LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Subscript error in 2007 when testing if Addin is installed

In Office 2007, I'm using the following function to determine whether an
Add-in is installed, but if the answer is "False", rather than false, I get
"Subscript out of range" error. Any idea what I'm doing wrong? How can I get
this to run right?

Private Function AddInInstalled(argName As String) As Boolean
'return true if an addin is installed:
If AddIns(argName).Installed = True Then
AddInInstalled = True
Else
AddInInstalled = False
End If
End Function

Thanks in advance...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Installed Addin file opens when it shouldn't Aaron Excel Discussion (Misc queries) 3 February 6th 08 11:13 PM
subscript out of range error in Excel 2007 at Vista Feier Excel Programming 2 July 18th 07 05:20 AM
Unable to set installed property of addin polandjc Excel Programming 6 September 15th 05 02:29 PM
Testing for the presence of an AddIn? Maury Markowitz Excel Programming 3 April 1st 05 06:23 PM
Testing for an addin? Don Wiss Excel Programming 1 July 8th 04 04:10 AM


All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"