AnsweredAssumed Answered

vrf Excel activeX

Question asked by g.nied on Jan 26, 2005

Like • Show 0 Likes0
Comment • 16

<!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.2800.1106" name=GENERATOR></HEAD><BODY><DIV><SPAN class=231070018-27012005>Does anyone know if it's possible to write a VEE program to monitor a website for any changes made and email the changes to someone?</SPAN></DIV><DIV><SPAN class=231070018-27012005>Regards,</SPAN></DIV><DIV><SPAN class=231070018-27012005>Lee</SPAN></DIV><P><FONT size=2>Lee Hudson, R&D Scientist<BR>LumiLeds Lighting, U.S., LLC<BR>370 West Trimble Road, MS 91ML<BR>San Jose, CA 95131<BR>(408) 435-5834<BR>(408) 435-6574 FAX <BR><FONT color=#0000ff>lee.hudson@lumileds.com</FONT></FONT><FONT size=2><BR></FONT><A href="http://www.lumileds.com/"><FONT color=#0000ff size=2>http://www.lumileds.com</FONT></A><BR><A href="http://www.luxeon.com/"><FONT color=#0000ff size=2>http://www.luxeon.com</FONT></A><BR><FONT size=2><FONT color=#0000ff></P></FONT></FONT><DIV> </DIV>---<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@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>

No one else has this question

Outcomes

16 Replies

VRFuser Jan 24, 2005 10:35 PM
Mark Correct
Correct Answer
Is it a .VEE program? If so, make it into a .VXE and it should all take care of itself.

Jeff Davis
Lead Test Engineer
CDI Engineering Solutions Aerospace Technologies
Embedded Systems and Electronics
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435

> -----Original Message-----
> From: Bern Muller [mailto:bernhard.muller@dlcdesignaudio.com]
> Sent: Tuesday, January 25, 2005 12:30 PM
> To: VRF
> Subject: [vrf] Excel activeX
>
>
> If I develop a VEE application that communicates with Excel
> on a computer
> running Office 97 (Hey! it works), I check the box marked
> "Microsoft Excel
> 8.0 object Library" in the Active X Automation references menu, and of
> course, everything works fine. If I now migrate that application to a
> different computer running Office 2000, it also works just fine.
>
> On the other hand, if I develop an application on the Office
> 2000 machine,
> and migrate it to the Office 97 machine, it won't run without
> my starting
> the development VEE and changing the checkbox from 9.0 object
> library to 8.0
> object library and resaving the program. Of course, the 8.0
> object library
> checkbox isn't available on the Office 2000 machine.
>
> Is there any way to automate this? That is to say, I want to
> be able to
> develop on the Office 2000 machine and migrate the
> application to the Office
> 97 machine as transparently as it works the opposite way. By
> the way, I
> don't do anything more complicated than open a worksheet.
>
>
>
> ---
> You are currently subscribed to vrf as: jeff.davis@cdi-es.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@agilent.com".
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>
> _____________________________________________________________________
> This e-mail message has been scanned for the presence of all
> known computer viruses by the MessageLabs Virus Control
> Center. However, it is still recommended that you use local
> virus scanning software to monitor for the presence of viruses.
>

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

---
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@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
mark.goldberg Jan 24, 2005 10:59 PM
Mark Correct
Correct Answer
Jeff,

I hope you are wrong, as it would seem that the "Shawn Bot" has become self
aware and has begun producing its own offspring, Arbot. I have asked the
question in the past, "Did Shawn create Arbot or did Arbot create Shawn??"

Mark

-----Original Message-----
From: Davis, Jeff [mailto:jeff.davis@cdi-es.com]
Sent: Tuesday, January 25, 2005 1:16 PM
To: VRF
Subject: [vrf] Re: Excel activeX

Like I said back before y2K, Shawn is a bot program and not a real human
being. The "Shawn" VEE solution generator script is actually being hosted up
via an Agilent server somewhere in the bowels of the Rocky Mountains.

Agilent programmed the Shawn script to spout forth correct and helpful
answers with a quality rating of 99.9995%. What you have here is one of the
rare defects that has been factored in to the Shawn script sigma rating. All
is well, the script is working as designed.

Jeff Davis
Lead Test Engineer
CDI Engineering Solutions Aerospace Technologies
Embedded Systems and Electronics
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435

> -----Original Message-----
> From: Bern Muller [mailto:bernhard.muller@dlcdesignaudio.com]
> Sent: Tuesday, January 25, 2005 02:06 PM
> To: VRF
> Subject: [vrf] Re: Excel activeX
>
>
> I am awestruck! Shawn seems to be wrong!!!!
>
> The very long libid number is identical on both computers,
> but the Excel 9.0
> object library reads 8.0 and the Excel9.olb reads Excel8.olb
> on the Office
> 97 computer. Changing both of those works.
>
> Thanks for the tip, though. I think I'll write something to automate
> changing that.
>
> There is one further hitch. How to do locked run time files?
> Just convert
> them always on the office 97 computer, I guess.
>
> ----- Original Message -----
> From: "Shawn Fessenden" <shawn@testech-ltd.com>
> To: "'Bern Muller'" <bernhard.muller@dlcdesignaudio.com>; "'VRF'"
> <vrf@agilent.com>
> Sent: Tuesday, January 25, 2005 2:36 PM
> Subject: RE: [vrf] Excel activeX
>
>
> > > Is there any way to automate this?
> >
> > Swap the CLSIDs that appear in the .vee file. Check your
> own sources to be
> > sure, but version 9 shows up as:
> >
> > (device 0 ROOTCONTEXT
> > (automationRefs
> > (automationRef 1
> > (libid "{00020813-0000-0000-C000-000000000046}")
> > (desc "Microsoft Excel 9.0 Object Library")
> > (filename "C:\Program Files\Microsoft Office\Office\EXCEL9.OLB")
> > (verMajor 1)
> > (verMinor 3)
> > (lcid 0)))
> >
> > libid is the one you're after. The filename doesn't matter
> so much, nor
> > description.
> > -SHAWN-
> >
> >
> >
>
>
>
> ---
> You are currently subscribed to vrf as: jeff.davis@cdi-es.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@agilent.com".
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>
> _____________________________________________________________________
> This e-mail message has been scanned for the presence of all
> known computer viruses by the MessageLabs Virus Control
> Center. However, it is still recommended that you use local
> virus scanning software to monitor for the presence of viruses.
>

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

---
You are currently subscribed to vrf as: Mark.Goldberg@ATK.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@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@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 Jan 24, 2005 11:09 PM
Mark Correct
Correct Answer
> I am awestruck! Shawn seems to be wrong!!!!

Egads! You mean I have to come up with something to atone for this??

Seriously though, I'm bummin. MS has broken the same immutability laws that
they came up with and make everybody else agree to. Seems what's good for
the gander is not good for the goose.
-SHAWN-

---
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@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 Jan 24, 2005 11:23 PM
Mark Correct
Correct Answer
> I am awestruck! Shawn seems to be wrong!!!!

Ah yes, once again it's my own fault! That clsid is used to identify an
Excel Worksheet (i.e. a document object - which can of course mutate). It
doesn't identify any particular version of Excel. Sorry, my bad.

Versional dependencies can be taken care of by starting an application
instance instead of a document instance. The ProgID string can contain a
versional suffix.

That is, CreateObject("Excel.Application") will always start an instance of
the latest installed version of the Excel object library.
CreateObject("Excel.Application.8") will always start version 8 (aka Office
97). If version 9 supports version 8's interfaces, then version 9 will start
a version 8 ... ah, version.

I'll try all this stuff out later.
-SHAWN-

---
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@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 Jan 24, 2005 11:35 PM
Mark Correct
Correct Answer
I should mention right away that the best way to get VEE to ignore versional
differences is to simply uncheck the reference in the "Automation
References..." dialog.

VEE doesn't really need the reference unless you use one of the libraries
labels in place of a number. CreateObject("Excel.Application") will always
start whatever the most recent version of Excel is installed. Naturally you
sometimes have to worry about the differences, but for just opening a sheet
it probably doesn't matter much.
-SHAWN-

---
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@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 Jan 24, 2005 11:38 PM
Mark Correct
Correct Answer
Man, it's really hard to carry on a conversation when earlier thoughts are
preempted by later ones.

Is this what schizophrenia is like?
-SHAWN-

---
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@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 Jan 24, 2005 11:52 PM
Mark Correct
Correct Answer
Thanks, but I tried that. It doesn't work. When starting up the .vxe, it
complains it cannot find the proper reference and closes.

Speaking of locked run time versions, do they run faster? They certainly are
smaller.

----- Original Message -----
From: "Davis, Jeff" <jeff.davis@cdi-es.com>
To: "Bern Muller" <bernhard.muller@dlcdesignaudio.com>; "VRF"
<vrf@agilent.com>
Sent: Tuesday, January 25, 2005 2:35 PM
Subject: RE: [vrf] Excel activeX

Is it a .VEE program? If so, make it into a .VXE and it should all take care
of itself.

Jeff Davis
Lead Test Engineer
CDI Engineering Solutions Aerospace Technologies
Embedded Systems and Electronics
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435

> -----Original Message-----
> From: Bern Muller [mailto:bernhard.muller@dlcdesignaudio.com]
> Sent: Tuesday, January 25, 2005 12:30 PM
> To: VRF
> Subject: [vrf] Excel activeX
>
>
> If I develop a VEE application that communicates with Excel
> on a computer
> running Office 97 (Hey! it works), I check the box marked
> "Microsoft Excel
> 8.0 object Library" in the Active X Automation references menu, and of
> course, everything works fine. If I now migrate that application to a
> different computer running Office 2000, it also works just fine.
>
> On the other hand, if I develop an application on the Office
> 2000 machine,
> and migrate it to the Office 97 machine, it won't run without
> my starting
> the development VEE and changing the checkbox from 9.0 object
> library to 8.0
> object library and resaving the program. Of course, the 8.0
> object library
> checkbox isn't available on the Office 2000 machine.
>
> Is there any way to automate this? That is to say, I want to
> be able to
> develop on the Office 2000 machine and migrate the
> application to the Office
> 97 machine as transparently as it works the opposite way. By
> the way, I
> don't do anything more complicated than open a worksheet.
>
>
>
> ---
> You are currently subscribed to vrf as: jeff.davis@cdi-es.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@agilent.com".
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>
> _____________________________________________________________________
> This e-mail message has been scanned for the presence of all
> known computer viruses by the MessageLabs Virus Control
> Center. However, it is still recommended that you use local
> virus scanning software to monitor for the presence of viruses.
>

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

---
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@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 Jan 25, 2005 12:05 AM
Mark Correct
Correct Answer
I am awestruck! Shawn seems to be wrong!!!!

The very long libid number is identical on both computers, but the Excel 9.0
object library reads 8.0 and the Excel9.olb reads Excel8.olb on the Office
97 computer. Changing both of those works.

Thanks for the tip, though. I think I'll write something to automate
changing that.

There is one further hitch. How to do locked run time files? Just convert
them always on the office 97 computer, I guess.

----- Original Message -----
From: "Shawn Fessenden" <shawn@testech-ltd.com>
To: "'Bern Muller'" <bernhard.muller@dlcdesignaudio.com>; "'VRF'"
<vrf@agilent.com>
Sent: Tuesday, January 25, 2005 2:36 PM
Subject: RE: [vrf] Excel activeX

> > Is there any way to automate this?
>
> Swap the CLSIDs that appear in the .vee file. Check your own sources to be
> sure, but version 9 shows up as:
>
> (device 0 ROOTCONTEXT
> (automationRefs
> (automationRef 1
> (libid "{00020813-0000-0000-C000-000000000046}")
> (desc "Microsoft Excel 9.0 Object Library")
> (filename "C:\Program Files\Microsoft Office\Office\EXCEL9.OLB")
> (verMajor 1)
> (verMinor 3)
> (lcid 0)))
>
> libid is the one you're after. The filename doesn't matter so much, nor
> description.
> -SHAWN-
>
>
>

---
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@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 Jan 25, 2005 12:15 AM
Mark Correct
Correct Answer
Like I said back before y2K, Shawn is a bot program and not a real human being. The "Shawn" VEE solution generator script is actually being hosted up via an Agilent server somewhere in the bowels of the Rocky Mountains.

Agilent programmed the Shawn script to spout forth correct and helpful answers with a quality rating of 99.9995%. What you have here is one of the rare defects that has been factored in to the Shawn script sigma rating. All is well, the script is working as designed.

Jeff Davis
Lead Test Engineer
CDI Engineering Solutions Aerospace Technologies
Embedded Systems and Electronics
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435

> -----Original Message-----
> From: Bern Muller [mailto:bernhard.muller@dlcdesignaudio.com]
> Sent: Tuesday, January 25, 2005 02:06 PM
> To: VRF
> Subject: [vrf] Re: Excel activeX
>
>
> I am awestruck! Shawn seems to be wrong!!!!
>
> The very long libid number is identical on both computers,
> but the Excel 9.0
> object library reads 8.0 and the Excel9.olb reads Excel8.olb
> on the Office
> 97 computer. Changing both of those works.
>
> Thanks for the tip, though. I think I'll write something to automate
> changing that.
>
> There is one further hitch. How to do locked run time files?
> Just convert
> them always on the office 97 computer, I guess.
>
> ----- Original Message -----
> From: "Shawn Fessenden" <shawn@testech-ltd.com>
> To: "'Bern Muller'" <bernhard.muller@dlcdesignaudio.com>; "'VRF'"
> <vrf@agilent.com>
> Sent: Tuesday, January 25, 2005 2:36 PM
> Subject: RE: [vrf] Excel activeX
>
>
> > > Is there any way to automate this?
> >
> > Swap the CLSIDs that appear in the .vee file. Check your
> own sources to be
> > sure, but version 9 shows up as:
> >
> > (device 0 ROOTCONTEXT
> > (automationRefs
> > (automationRef 1
> > (libid "{00020813-0000-0000-C000-000000000046}")
> > (desc "Microsoft Excel 9.0 Object Library")
> > (filename "C:\Program Files\Microsoft Office\Office\EXCEL9.OLB")
> > (verMajor 1)
> > (verMinor 3)
> > (lcid 0)))
> >
> > libid is the one you're after. The filename doesn't matter
> so much, nor
> > description.
> > -SHAWN-
> >
> >
> >
>
>
>
> ---
> You are currently subscribed to vrf as: jeff.davis@cdi-es.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@agilent.com".
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>
> _____________________________________________________________________
> This e-mail message has been scanned for the presence of all
> known computer viruses by the MessageLabs Virus Control
> Center. However, it is still recommended that you use local
> virus scanning software to monitor for the presence of viruses.
>

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

---
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@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 Jan 25, 2005 12:17 AM
Mark Correct
Correct Answer
> If I don't check the box, I get an error message on trying to
> run the program: "There isn't any type information loaded for
> excel.application."

Pity. It helps a great deal in VEE 5. I didn't realize it was necessary in
later versions. And here I thought we were supposed to be taking steps
forward!
-SHAWN-

---
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@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 Jan 25, 2005 1:13 AM
Mark Correct
Correct Answer
If I don't check the box, I get an error message on trying to run the
program: "There isn't any type information loaded for excel.application."

And there is a red box around the formula box that says:
xlapp=createobject("excel.application")

And, of course, when I check the box, it works.

----- Original Message -----
From: "Shawn Fessenden" <shawn@testech-ltd.com>
To: "VRF" <vrf@agilent.com>
Sent: Tuesday, January 25, 2005 4:35 PM
Subject: [vrf] Re: Excel activeX

> I should mention right away that the best way to get VEE to ignore
versional
> differences is to simply uncheck the reference in the "Automation
> References..." dialog.
>
> VEE doesn't really need the reference unless you use one of the libraries
> labels in place of a number. CreateObject("Excel.Application") will always
> start whatever the most recent version of Excel is installed. Naturally
you
> sometimes have to worry about the differences, but for just opening a
sheet
> it probably doesn't matter much.
> -SHAWN-
>
>
>
> ---
> You are currently subscribed to vrf as: bernhard.muller@dlcdesignaudio.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@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@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
qigao Jan 25, 2005 8:09 PM
Mark Correct
Correct Answer
Is there a DeclareVariable for xlapp? If so, is it declared as a
specific type? If so, make it an Object of Any, or just use an output
terminal or SetVariable.

My guess is that if you declared the variable specifically as a type,
VEE will try to check if you really are creating the right type of
object. That "type information not loaded" error probably comes from
there.

Other people may not see this error probably because they didn't declare
it as a specific type.

Qi

-----Original Message-----
From: Bern Muller [mailto:bernhard.muller@dlcdesignaudio.com]
Sent: Tuesday, January 25, 2005 2:13 PM
To: VRF
Subject: [vrf] Re: Excel activeX

If I don't check the box, I get an error message on trying to run the
program: "There isn't any type information loaded for
excel.application."

And there is a red box around the formula box that says:
xlapp=createobject("excel.application")

And, of course, when I check the box, it works.

----- Original Message -----
From: "Shawn Fessenden" <shawn@testech-ltd.com>
To: "VRF" <vrf@agilent.com>
Sent: Tuesday, January 25, 2005 4:35 PM
Subject: [vrf] Re: Excel activeX

> I should mention right away that the best way to get VEE to ignore
versional
> differences is to simply uncheck the reference in the "Automation
> References..." dialog.
>
> VEE doesn't really need the reference unless you use one of the
libraries
> labels in place of a number. CreateObject("Excel.Application") will
always
> start whatever the most recent version of Excel is installed.
Naturally
you
> sometimes have to worry about the differences, but for just opening a
sheet
> it probably doesn't matter much.
> -SHAWN-
>
>
>
> ---
> You are currently subscribed to vrf as:
bernhard.muller@dlcdesignaudio.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@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: qi_gao@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@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@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 Jan 25, 2005 9:16 PM
Mark Correct
Correct Answer
Take a look at VM1602 at www.vxitech.com

-----Original Message-----
From: Alex.Barrett@raytheon.co.uk [mailto:Alex.Barrett@raytheon.co.uk]
Sent: Wednesday, January 26, 2005 12:41 PM
To: VRF
Subject: [vrf] exact real timing on a scope (or something)

Hi vrf... a weird test related problem this...

I need to find the actual time that a pulse goes high on a scope.

(eg, the pulse went high at 10:24.32pm)

the propogation delay between scope, gpib, vee and the PC would be too
long, so essentially I need to know if anyone knows of a scope (or any
other piece of equipment) which will log the actual time of a pulse
occuring..

Any suggestions wouldbe gratefully received...

Al.

---
You are currently subscribed to vrf as: omer.akbas@arcelik.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@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________

---
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@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 Jan 25, 2005 11:36 PM
Mark Correct
Correct Answer
> Is there any downside to not declaring the type?

You probably won't be able to use any of the constant or enum labels and so
will have to use numbers instead. The labels like xlFirst or xlLast that is.
Don't quote me on that though. I'm not exactly batting 1000 on this thread
:-)

Other than that I can't think of any. VEE might do some "binding
preparation", but no ActiveX method or property access function can be truly
early bound so there's no penalty there.

Nope, mostly the advantage of being version independent probably outweighs
the disadvantage of giving up labels (or just define your own labels in
initialization). Just be ready to investigate versional dependencies though.
If something works one way with version 8 and a different way with version
9... well, I can't think of anything off the top of my head but I'm sure
there's something there.
-SHAWN-

---
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@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 Jan 26, 2005 12:22 AM
Mark Correct
Correct Answer
Well, that seems to have done the trick. I still have to declare the variable, but
don't specify type, and voila! it works. Is there any downside to not declaring the
type?

For years now, I have been using a model of accessing Excel I found somewhere that
specified type, etc and just copied it when I needed it.

thanks

bern muller

----- Original Message -----

My guess is that if you declared the variable specifically as a type,
VEE will try to check if you really are creating the right type of
object. That "type information not loaded" error probably comes from
there.

Other people may not see this error probably because they didn't declare
it as a specific type.

Qi

---
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@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 Jan 26, 2005 9:07 AM
Mark Correct
Correct Answer

----- Original Message -----
From: "Shawn Fessenden" <shawn@testech-ltd.com>
To: "'bern muller'" <bernhard.muller@dlcdesignaudio.com>; "'VRF'" <vrf@agilent.com>
Sent: Wednesday, January 26, 2005 4:36 PM
Subject: RE: [vrf] Re: Excel activeX

> > Is there any downside to not declaring the type?
>
> You probably won't be able to use any of the constant or enum labels and so
> will have to use numbers instead. The labels like xlFirst or xlLast that is.
> Don't quote me on that though. I'm not exactly batting 1000 on this thread
>

You are batting 1000 on this issue. I found the same thing. Using the approrpriate
integers works fine. I assume there is little chance that
"-4140" which means "xlmaximize" in Office 2000 means something else in Office 97 or
XP.

bern

---
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@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

vrf Excel activeX

Outcomes

Related Content

Recommended Content