ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating VB OCX that uses MS Excel, but not always (https://www.excelbanter.com/excel-programming/312079-creating-vbulletin-ocx-uses-ms-excel-but-not-always.html)

Allen[_13_]

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