#1  
Old 21st June 2005, 10:48 AM
Harold.legg
 
Posts: n/a
Default OT - Excel OLE help

One part of a Delphi/Nexus application I am writing uses OLE automation to
call Excel. Since MS has a nasty habit of changing the number of parameters
used to call a function, I need to programatically determine which version
of Excel is installed in the machine I am running on.

I hope someone here has an answer (and if possible an example) of this.

TIA for your help

Harold Legg


  #2  
Old 21st June 2005, 12:02 PM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: OT - Excel OLE help

Harold.legg wrote:

> One part of a Delphi/Nexus application I am writing uses OLE automation to
> call Excel. Since MS has a nasty habit of changing the number of parameters
> used to call a function, I need to programatically determine which version
> of Excel is installed in the machine I am running on.
>
> I hope someone here has an answer (and if possible an example) of this.


Excel := CreateOleObject('excel.application');
Version := Excel.Version;



--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm
  #3  
Old 26th June 2005, 01:42 AM
Harold.legg
 
Posts: n/a
Default Re: OT - Excel OLE help

Sorry it took me a couple of days to test this out. Found it, works
perfectly. Thank you for once again being patient - sometimes I can't see
what is staring me in the face until someone with another set of eyes
reminds me where to look.

Harold

"Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> wrote in message
news:xn0e3rgd61k3pkp004@news.nexusdb.com...
> Harold.legg wrote:
>
>> One part of a Delphi/Nexus application I am writing uses OLE automation
>> to
>> call Excel. Since MS has a nasty habit of changing the number of
>> parameters
>> used to call a function, I need to programatically determine which
>> version
>> of Excel is installed in the machine I am running on.
>>
>> I hope someone here has an answer (and if possible an example) of this.

>
> Excel := CreateOleObject('excel.application');
> Version := Excel.Version;
>
>
>
> --
>
> Hannes Danzl [NexusDB Developer]
> Newsgroup archive at http://www.tamaracka.com/search.htm





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC, Excel and Memo-BLOB: Missing data Karsten Lehnart nexusdb.public.support.odbc 6 21st November 2005 04:35 AM
NexusDB 202 and ODBC driver and Excel Kick Martens nexusdb.public.support.odbc 2 27th September 2005 06:54 AM
OT - Excel import to NexusDB Srinivasan Iyer nexusdb.public.discussions 3 12th December 2003 01:58 PM
OT: Export-Tool NEXUS-->Excel Andreas Brietz nexusdb.public.discussions 10 3rd October 2003 09:32 PM


All times are GMT +11. The time now is 11:24 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.