There no boolean that determines if it appends or not.  It works
perfectly for me on WinXP, Office XP and LV6.02.  If you are using an
older version like Office 97, you will need to change the
Range->Value2 to Range->Value in the Set Cell Value.vi, otherwise no
new data will be appended.

Open up the Excel Get Used Range.vi before running the main vi and
check what number is returned for Used Rows.  This number needs to be
the last row used by the original data.  This number is added to the
loop index to increment the row address, starting at the last location
+1.

If you are getting Used Rows = 1, there is something wrong with how
you select the sheet or something odd in how the data is organized.
Are you appending into hidden rows?

Michael

Reply via email to