AnsweredAssumed Answered

vrf Excel Range(X).Select error

Question asked by fukui.yutaka on Mar 22, 2004
Hi,


I'm not sure wheather this hint solves this error or not.

But, how about replacing "ExcelApp.....Range(B).Select" by

"ExcelApp.....Range(B:B).Select".


Regards,


> hermann.ruckerbauer@infineon.com wrote:
>
> Hello, maye somebody can give me a hint ...
>
>
> We do have some ActiveX funtion to access data in Excel and we are
> getting some kind of random error just selecting a Cell.
> We are giving the command "ExcelApp.....Range(B).Select" and most of
> the time this is working fine. But sometimes we are
> getting an error like "The Select porperty of Range object could not
> be assigned"  (free translated from german).
> I can post the exact error message if this helps (need to transfer it
> first from a standalone pc)
>
>
> Before this Command we are making a screenshot on a scope, and
> transferred this .png file via GPIB. So this is the first ActiveX
> comand
> after some kind of other commands. And as I mentioned already we do
> not get a reproducable error. Sometimes this runs
> 10 times without problems, sometimes the error message pops up every
> second run.
>
> Thanks for every hint ...
>
>
> Hermann
> ---
> You are currently subscribed to vrf as: fukui.yutaka@jp.fujitsu.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".

--
*****************************************************************
*  $BJ!0f!!K-!J (BFUKUI Yutaka)
* E-Mail: fukui.yutaka@jp.fujitsu.com
*  $BIY;NDL3t<02q<R!!@n:j9)>l (B
*  $B$b$N$E$/$j?d?JKIt!&@8;:5;=Q3+H/E}3gIt!K7WB,@_Hw3+H/It (B
*  $B7WB,@_Hw3+H/It (BHomePage http://www.psl.fujitsu.co.jp/htd2/ksk/
*  $B@n:j;TCf866h>e>.EDCf#4 (B- $B#1 (B- $B#1!!M9JXHV9f!' (B211-8588
* TEL  $B!!30@~ (B 044-754-3657, $B!!Fb@~ (B 711-3-1966,7
* FAX  $B!!30@~ (B 044-754-3509, $B!!Fb@~ (B 711-3-5359
*****************************************************************

---
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".

Outcomes