Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Force particular Excel version loading with CreateObject?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RB Smissaert - 23 Mar 2006 21:45 GMT
Trying to figure out what the best way is to deal with the
problem of installing an .xla add-in when the user has multiple versions of
Excel.

My installation now works with COM automation in an INNO script.
It all looks slightly different as INNO uses Pascal, but bascically it uses
CreateObject.

Now the question is how can I force a particular Excel version with
CreateObject.
I know that sticking the version number after Application doesn't work:
CreateObject("Excel.Application.9")  etc.

I suppose the simplest and safest way is to just not automate this at all
but tell the user to
open Excel (of their choice) and do Tools, Add-ins etc.
I am still hoping thought that there might be a way how to do this.

Thanks for any advice.

RBS
Charles Williams - 24 Mar 2006 09:53 GMT
Works OK if you explicitly write the addin registry keys for all versions
(no need to open Excel at all).

regards
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

> Trying to figure out what the best way is to deal with the
> problem of installing an .xla add-in when the user has multiple versions
[quoted text clipped - 17 lines]
>
> RBS
bart.smissaert@gmail.com - 24 Mar 2006 10:32 GMT
Yes, I can see it can be done via the registry, but for simplicity I
wanted to do
it via COM. I suppose there just is no way to force the version that
way.

RBS

> Works OK if you explicitly write the addin registry keys for all versions
> (no need to open Excel at all).
[quoted text clipped - 27 lines]
> >
> > RBS
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.