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,452
Default Force particular Excel version loading with CreateObject?

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

 
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
Createobject returns null in Excel [email protected] Excel Discussion (Misc queries) 1 March 27th 06 04:04 AM
Templates not loading as xls version Gizmo63 Excel Programming 3 February 8th 06 04:26 PM
How to force VBA to create an Excel.Application object of specified version of Excel? surotkin[_3_] Excel Programming 0 November 1st 05 07:32 PM
Excel CreateObject on server Dennis Redfield Excel Programming 9 July 15th 05 10:09 PM
Why can't create Excel.Application using CreateObject? [email protected] Excel Programming 0 May 6th 04 03:46 AM


All times are GMT +1. The time now is 01:33 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"