> Problems can occur if you launch too many Excel instances carelessly.
See? Greg is a very wise man. It's been a while since I mentioned it, but
there is some evil associated with CreateObject: it will create a new
instance of the server. GetObject on the other hand will reuse an existing
server if possible, and if the server isn't running it will start it.
If you're doing a lot of Excel stuff and finding it rather more than you're
willing to put up with check out his add-in.
-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".
See? Greg is a very wise man. It's been a while since I mentioned it, but
there is some evil associated with CreateObject: it will create a new
instance of the server. GetObject on the other hand will reuse an existing
server if possible, and if the server isn't running it will start it.
If you're doing a lot of Excel stuff and finding it rather more than you're
willing to put up with check out his add-in.
-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".
idea is to create a new log, or
add to an existing one, depending on whether the workbook exists already -
and
I've figured out how to do this. What I can't figure out how to find the
last entry on the worksheet, so that I can continue to write data after this
entry. The only way I can think of so far is to read each row until I get
an error, or save the "pointer" in a specific cell, and read this back to
enter more data. Is there a better way of doing this?
Reiner Schlieker
Test Equipment Designer
Siemens Milltronics Process Instruments Inc.
Phone: (705) 740-7553
Fax: (705) 740-7692
Email: reiner.schlieker@siemens.com
Web: www.siemens-milltronics.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".
1. Build a FORMULA Object and put this in it:
---------------------------------------------
set range = ExcelApp.Range("A2:A65536");
ExcelApp.WorksheetFunction.CountBlank(range);
---------------------------------------------
2. Wire the output of item one to a formula box with this in it:
---------------------------------------------
65.536k-A
---------------------------------------------
The RESULT output of the formula box above (step 2) should give you the
TOTAL number of elements that are NONBLANK in Column A...That same result
should be the last row of valid data for Column A...It works well for me.
NOTE: 65.536k is the maximum number of rows that Excel supports.
Jeff Davis
Embedded Systems - CDI Technical Services
3137 E Elwood # 160
Phoenix, Arizona 85034
Phone: (602)431-4497 (x226)
Cell: (480)330-1431
Fax: (602)431-4435
> -----Original Message-----
> From: Schlieker, Reiner [mailto:reiner.schlieker@siemens.com]
> Sent: Monday, December 16, 2002 07:50
> To: VEE vrf
> Subject: [vrf] Excel
>
>
> I'm trying to write some logging functions for my functional
> testers. The
> idea is to create a new log, or
> add to an existing one, depending on whether the workbook
> exists already -
> and
> I've figured out how to do this. What I can't figure out how
> to find the
> last entry on the worksheet, so that I can continue to write
> data after this
> entry. The only way I can think of so far is to read each
> row until I get
> an error, or save the "pointer" in a specific cell, and read
> this back to
> enter more data. Is there a better way of doing this?
>
>
> Reiner Schlieker
> Test Equipment Designer
> Siemens Milltronics Process Instruments Inc.
> Phone: (705) 740-7553
> Fax: (705) 740-7692
> Email: reiner.schlieker@siemens.com
> Web: www.siemens-milltronics.com
>
>
>
> ---
> 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@it.lists.it.agilent.com".
> If you need help with the mailing list send a message to
> "owner-vrf@it.lists.it.agilent.com".
>
> _____________________________________________________________________
> 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
>
_____________________________________________________________________
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
---
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".
Here's what I do
Wks.Activate();
//Activate worksheet
Excelapp.Selection.SpecialCells(xlCellTypeLastCell).Select;
//Select Last Cell
actaddr=excelapp.activecell.address;
//Get Last Cell address
revpos=strPosChar(strrev(actaddr),"$");
//Find first $ on right of string
lastrownum=asint32(strfromthru(actaddr,strlen(actaddr)-revpos,strlen(actaddr)));
//Parse string for row number
emptyrownum = lastrownum+1;
//Increment row +1
actcell=astext("A"+emptyrownum);
//Format first empty cell address
Wks.Range(actcell).select;
//Set first empty cell as active cell
Hope this helps
--
Regards,
Rich
===================
Richard Kleinhenz
Wafer Engineering
845-892-2617
scubaman@us.ibm.com
===================
"Schlieker, Reiner"
<reiner.schlieker@s To: "VEE vrf" <vrf@it.lists.it.agilent.com>
iemens.com> cc:
Subject: [vrf] Excel
12/16/2002 09:49 AM
Please respond to
"Schlieker, Reiner"
I'm trying to write some logging functions for my functional testers. The
idea is to create a new log, or
add to an existing one, depending on whether the workbook exists already -
and
I've figured out how to do this. What I can't figure out how to find the
last entry on the worksheet, so that I can continue to write data after
this
entry. The only way I can think of so far is to read each row until I get
an error, or save the "pointer" in a specific cell, and read this back to
enter more data. Is there a better way of doing this?
Reiner Schlieker
Test Equipment Designer
Siemens Milltronics Process Instruments Inc.
Phone: (705) 740-7553
Fax: (705) 740-7692
Email: reiner.schlieker@siemens.com
Web: www.siemens-milltronics.com
---
You are currently subscribed to vrf as: scubaman@us.ibm.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".
Excel can tell you which cells are used:
'SheetX.UsedRange' will return the used range in an Excel spreadsheet object and 'SheetX.UsedRange.Address' will return the address of the used range (not surprisingly!)
Hope this helps...
-----Original Message-----
From: Schlieker, Reiner [mailto:reiner.schlieker@siemens.com]
Sent: 16 December 2002 14:50
To: VEE vrf
Subject: [vrf] Excel
I'm trying to write some logging functions for my functional testers. The
idea is to create a new log, or
add to an existing one, depending on whether the workbook exists already -
and
I've figured out how to do this. What I can't figure out how to find the
last entry on the worksheet, so that I can continue to write data after this
entry. The only way I can think of so far is to read each row until I get
an error, or save the "pointer" in a specific cell, and read this back to
enter more data. Is there a better way of doing this?
Reiner Schlieker
Test Equipment Designer
Siemens Milltronics Process Instruments Inc.
Phone: (705) 740-7553
Fax: (705) 740-7692
Email: reiner.schlieker@siemens.com
Web: www.siemens-milltronics.com
---
You are currently subscribed to vrf as: Richard.Wise@raymarine.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".
I have a ****.csv file for use with EXCEL .. does anyone the transaction to
wite say
Fecha/Hora Canal 1 Canal 2 etc.
in the first row the CRLF to provide a header
I have dome it before cant remeber !
regards
Malcolm Bint
---
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".
There are a couple of mentions of using csv on our website - please
have a look under www.preciselyso.co.uk, go the the Site Index and look
under "comma-separated values file".
Let me know if this does not answer your question.
Regards,
Mike Watts
---
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".
<b><span style='font-weight:bold'>From:</span></b> csboyd@micron.com[mailto:csboyd@micron.com]
<b><span style='font-weight:bold'>Sent:</span></b> Monday, August 02, 2004 7:47PM
<b><span style='font-weight:bold'>Subject:</span></b> excel</span></font></p><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p><p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Howdo I open an existing workbook? I know how to create a new one from theexamples in the manual. I don't see anything on adding data to an existing one.</span></font></p><p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Thanks,</span></font>
<font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>CBoyd</span></font> </p></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>
I'm using VEE 7.5's Excel library/menu, which is a lot easier to use than ActiveX objects. But I found out that if I have more than one Excel file open, or if the file that I want VEE to open is already open, then when the program runs, it runs in the background. It reads from and writes to the cells just fine, but it hides behind the VEE program.
On the other hand, Excel does run in the foreground if the desired file was not already opened. But the problem with this case is that it obscures the pop-up message box to the operator and you can't tell that the program is waiting for a user response; And vice versa when you click on VEE to answer the pop-up message, Excel is obscured.
So, is there a way (without using ActiveX) to have the defined print area in Excel (or the print preview) be added to the user panel? The reason for this is so the operator can verify the data quickly. Thanks in advance f or any suggestions.
Regards,
Andie
</div>---You are currently subscribed to vrf as: rsb@soco.agilent.comTo 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".Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
If I open a new excel page and then closed it I received an error message from the program.
Question is, How can I have the program ignore the new excel page?
Cecil L. Gray
Real Estate Agent
Lawrenceville, GA
Cell: 678-387-8440
Fax: 866-820-4519
HYPERLINK "mailto:cecilgray@bellsouth.net%20"cecilgray@bellsouth.net
HYPERLINK "http://www.cecilgray.com"www.cecilgray.com
(Broker)
Platinum Real Estate
1415 Highway 85 North Suite 310-345
Fayetteville, GA 30214
(Broker) 404-559-0332
-----Original Message-----
From: Richard Walker [mailto:richardw@freqelec.com]
Sent: Thursday, August 02, 2007 12:28 PM
To: VRF
Subject: [vrf] vrf: Blanking frequency on N8973A NFA
VEE Users,
I cannot find a command to hide/blank the display frequencies on a N8973A NFA. Has anyone found a way to resolve this or a work around?
Thanks
Richard A. Walker
Sr. ATE Engineer
Frequency Electronics, Inc.
55 Charles Lindbergh Blvd.
Mitchel Field, NY 11553
Tel: (516) 794-4500 X2255
Fax: 516-794-4340
mailto: richardw@freqelec.com
---
You are currently subscribed to vrf as: cecilgray@bellsouth.net
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
_____
Plan your next roadtrip with HYPERLINK "http://www.mapquest.com/?ncid=mpqmap00030000000004"
MapQuest.com: America's #1 Mapping Site.
--- You are currently subscribed to vrf as: ming_meng@agilent.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body. 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". Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive". Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Others probably give you much more detailed answer, here just my 2 cents.
In Vee you can write a program so easy, that often you do not pay attention to program flow. You may have two things triggered from one source without "forced" order. When you copy & paste stuff from your program to another this "unforced" flow order may behave differently. Same thing if you change Vee versions.
I have learned this by the hard way, and try to use forced order (use the do boxes!) more or less everywhere, if it is crucial that one thing happens before another. I notice that this is quite common mistake (fixing other people's programs).
Hope this makes sense, if not, wait others to response
The Boss reaction seems to be a typical Dilbert thing. He was embarrassed by his "stupid" mistake and making a loud noise to cover up.
BR, Tapio
_____
From: ext Douglas Rudrow [mailto:drudrow@Aurora.com]
Sent: 25 April, 2008 02:22
To: VRF
Subject: [vrf] VEE issues...
Greetings all,
I’ve got a dilemma. I wrote a very simple program to communicate with an optical polarization controller. While I was at lunch today, my boss copied it to a different computer. When he tried to run it, VEE threw an error that it couldn’t open the GPIB interface. When I got back from lunch, he had sent me this long e-mail about how he’s losing confidence in VEE and we need a robust platform in the lab. In this particular case, Windows had failed to configure the plug and play GPIB interface (NI USB-GPIB HS). Of course I explained that if the equipment is not connected to the computer, no language in the world can talk to it, VEE simply pointed out that there was no GPIB interface.
The preface to this whole incident is: I have a much more complex test program that had worked for months on end with no problems, and then all of a sudden it stopped working with no changes to the test setup, the PC or the software. While troubleshooting this problem, I saw that the data and execution flow of the program was doing things I didn’t expect. Perhaps this is just a lack of true understanding of VEE program flow on my part, but I’ve been writing test code in VEE for over 13 years and I’d never seen this. In order to get the program running again, I had to revert back to a programming style I haven’t used since I was a rank amateur. I started using loads of variables instead of passing data through terminals. I know, it’s not efficient or elegant, but it’s working. My questions are: has anyone else run into problems like this? And has VEE program flow changed as operating systems and VEE have evolved?
Thanks in advance,
Doug
Douglas B. Rudrow
Systems Development Lab Technologist
Aurora Networks
2803 Mission College Blvd.
Santa Clara, California, 95054
U.S.A.
(408) 235-7000 Main
(408) 235 7084 Direct
HYPERLINK "mailto:rvilla@aurora.com"drudrow@aurora.com
---
You are currently subscribed to vrf as: tapio.ronkainen@nokia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".