AnsweredAssumed Answered

vrf Is Excel installed?

Question asked by warren.pickles on Nov 7, 2002

Like • Show 0 Likes0
Comment • 5

Thanks for all the replies to that. CreateObject in a formula box, with an
error output, works fine.
Warren Pickles

-----Original Message-----
From: Pickles, Warren
Sent: 07 November 2002 08:03
To: VEE vrf
Subject: [vrf] Is Excel installed?

Hi

Does anyone know how to query whether Excel is installed on a given PC, from
VEE?

Thanks,
Warren Pickles

---
You are currently subscribed to vrf as: Warren.Pickles@tycoelectronics.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".

If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

No one else has this question

Outcomes

5 Replies

VRFuser Nov 6, 2002 4:54 PM
Mark Correct
Correct Answer
Hi

Does anyone know how to query whether Excel is installed on a given PC, from
VEE?

Thanks,
Warren Pickles

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
warren.pickles Nov 6, 2002 5:02 PM
Mark Correct
Correct Answer
Hi

Does anyone know how to query whether Excel is installed on a given PC, from
VEE?

Thanks,
Warren Pickles

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
mwills Nov 6, 2002 5:27 PM
Mark Correct
Correct Answer
Warren,
     I may have misinterpreted your requirement but just a thought and
this is very crude.

Assuming that your program reads / writes to an excel file your program will
already have the excel Active-X reference checked, couldn't you either try
to create a new Excel object or perhaps try to open the workbook that you
want to read. In both cases add an error pin to the objects output if this
errors you can assume that excel is not installed (although this could have
errored for other reasons, if the file path is fixed and it is a file that
nobody else accesses then it is more likely that excel is not installed).
     Failing this I guess you will somehow need to search the registry
for an excel reference, over to some other smart cookie !

Regards,
Mark Wills

Principal ATE Engineer
Wireless Automotive System Group

> * E-mail: mwills@tycoelectronics.com
> * Phone: +44 (0)1908 574209 (direct line)
> * Phone: +44 (0)1908 574200 (switchboard)
> * Fax:     +44 (0)1908 574300 (fax)
>
Tyco Electronics UK Limited M/A-COM Division
Featherstone Road
Wolverton Mill
Milton Keynes
MK12 5EW

Creating chaos out of order !

-----Original Message-----
From: Pickles, Warren
Sent: 07 November 2002 08:03
To: VEE vrf
Subject: [vrf] Is Excel installed?

Hi

Does anyone know how to query whether Excel is installed on a given PC, from
VEE?

Thanks,
Warren Pickles

---
You are currently subscribed to vrf as: MWills@tycoelectronics.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".

If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
a-lehmann Nov 6, 2002 5:41 PM
Mark Correct
Correct Answer
Hello Warren,

I suggest to search for the file <C:ProgramsMSOfficeOfficeEXCEL9.OLB> (Excel2000)
or maybe <C:ProgrammeMSOfficeOfficeexcel8.olb> (Excel 97)
This file exists after a standard installation and it is used for ActiveX automation controls in
VEE.

Greetings

Andre Lehmann
IOM GmbH

"Pickles, Warren" schrieb:

> Hi
>
> Does anyone know how to query whether Excel is installed on a given PC, from
> VEE?
>
> Thanks,
> Warren Pickles
>

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Nov 6, 2002 6:21 PM
Mark Correct
Correct Answer
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD><BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px"><DIV><SPAN class=317264314-07112002><FONT size=1>I like this program, but I do not understand it at all.</FONT></SPAN></DIV><DIV><SPAN class=317264314-07112002><FONT size=1></FONT></SPAN> </DIV><DIV><SPAN class=317264314-07112002><FONT size=1>The ActiveX Automation Reference does not have the MS Excel Object Library selected (jn my case, Excel 9.0), so how does the "Set up Excel Work Sheet" object refer to any type of context of an Exel sheet ??</FONT></SPAN></DIV><DIV><SPAN class=317264314-07112002><FONT size=1></FONT></SPAN> </DIV><DIV><SPAN class=317264314-07112002><FONT size=1>I look at the "Declare Sheet" global and see that you have "SPECIFY OBJECT TYPE" checked, but there is no LIBRARY or CLASS selected because of the fact that the MS Excel Object Library is not loaded. Somehow, the "Set up Excel Work Sheet" formula box is able to return the text string "Micsrosoft Excel" if you comment out the ExcelApp.Quit(); and the 0; lines of the formula box (the last 2 lines).</FONT></SPAN></DIV><DIV><SPAN class=317264314-07112002><FONT size=1></FONT></SPAN> </DIV><DIV><SPAN class=317264314-07112002><FONT size=1>How does it do that ???</FONT></SPAN></DIV><DIV> </DIV><P><FONT size=2>Jeff Davis<BR>Embedded Systems - CDI Technical Services<BR>3137 E Elwood # 160<BR>Phoenix, Arizona 85034<BR>Phone: (602)431-4497 (x226)<BR>Cell: (480)330-1431<BR>Fax: (602)431-4435</FONT> </P><BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> James Atkin [mailto:James.Atkin@mitectelecom.biz]<BR><B>Sent:</B> Thursday, November 07, 2002 01:54<BR><B>To:</B> VEE vrf<BR><B>Subject:</B> [vrf] Re: Is Excel installed?<BR><BR></FONT></DIV> <DIV><FONT size=1><STRONG>Hi,</STRONG></FONT></DIV> <DIV><FONT size=1><STRONG></STRONG></FONT> </DIV> <DIV><FONT size=1><STRONG>You could use the 'CreateObject' call to do this.</STRONG></FONT></DIV> <DIV><FONT size=1><STRONG>Please see attached ...</STRONG></FONT></DIV> <DIV><FONT size=1><STRONG></STRONG></FONT> </DIV> <DIV><FONT size=1><STRONG>Best Regards,</STRONG></FONT></DIV> <DIV><FONT size=1><STRONG></STRONG></FONT> </DIV> <DIV><FONT size=1><STRONG>James</STRONG></FONT></DIV> <DIV> </DIV> <DIV><FONT size=1><STRONG>-------------------------------------------------------<BR>James Atkin BEng(Hons) MIEE<BR>Software Engineer<BR>Mitec Telecom Ltd<BR>The Arenson Centre<BR>Arenson Way<BR>Dunstable<BR>Bedfordshire<BR>LU5 5UL<BR>-------------------------------------------------------</STRONG></FONT></DIV><BR>_____________________________________________________________________<BR>This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com<BR></BLOCKQUOTE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@it.lists.it.agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML><HTML><BODY><BR>_____________________________________________________________________<BR>This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com<BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@it.lists.it.agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>
Like • Show 0 Likes0
Actions

vrf Is Excel installed?

Outcomes

Related Content

Recommended Content