![]() |
Creating VB OCX that uses MS Excel, but not always
I'm creating an ActiveX that will sometimes require interfacing with MS
Excel. It is important for me to be able to instantiate this ActiveX regardless of whether or not MS Excel is installed. In my User control module, Global declarations I have the following: Private WithEvents XLApp1 As Excel.Application ' This overrides any events the workbook may have ' thereby bypassing any macros they have (A good thing) If MS Excel is not installed it will crash on the line above. Is there something I can install (barring MS Excel) to at least get it to overcome this issue? Thanks much, Allen Segall |
All times are GMT +1. The time now is 12:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com