LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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


 
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
creating an excel add-in James Excel Discussion (Misc queries) 6 June 6th 08 02:15 PM
Creating an Excel TOC Brad Excel Worksheet Functions 4 August 11th 05 11:05 PM
after creating macro button, closed excel then restarted excel hjd43 Excel Discussion (Misc queries) 1 March 3rd 05 03:04 AM
Creating Excel add-ins from .Net ShockWave[_2_] Excel Programming 0 July 7th 04 06:12 PM


All times are GMT +1. The time now is 02:29 PM.

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

About Us

"It's about Microsoft Excel"