Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Egidius Bakker   on Aug 13 In MS Office Category.

  
Question Answered By: Priscilla Lewis   on Aug 13

One user opened Excel Tools > Add-Ins and checked the two addins, and still
got a failure (Can't find project  or library) when launching the .xls file  I
sent.

Would the following work for users  of a forms project I send for general use
(they have various versions of Office, which includes Excel):



Public Sub Auto_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
frmCorrectiveAction.Show
End Sub


Or is it also necessary for them to do something explicitly in VBA? (i.e.,
set up the Project Reference)...

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VBA Excel Project to Users Or get search suggestion and latest updates.


Tagged: