Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel Application.Addins.Add error 1004 (Read 3309 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel Application.Addins.Add error 1004
24.11.09 at 09:49:18
 
Excel Application.Addins.Add error 1004
 
There is an annoying bug in Excel in that the Addins.Add function returns an error when there is no active workbook.  
 
Workaround:
 
if application.activeworkbook is nothing then
  application.workbooks.add
end if
application.addins.add("yourfile.xla")
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1