09-15-2011 08:22 AM
Replace the Open New Worksheet function (so it doesn't make a new worksheet when you open the Workbook) then you need to find the next row to write in (unless you want to replace data). I've written a VI that does this and replaced the Row constant with the next row from the last time the Workbook was saved.
09-15-2011 09:24 AM
Can you please include the open specific worksheet.vi for me? since I don't know why I couldn't open that VI
thanks a lot Jim, you are the best ^^
thanks again,
Ery
09-15-2011 09:40 AM
Thanks, Problem solved!!
Thanks Jim ^^
09-19-2011 09:08 AM
Hi Jim, Sorry to bother you again, I just wonder how do you connect the get next xl row.vi to the cell value? I try to use the function you posted, but it's now working, I actually need to get next xl column instead or row, since I need the output value to excel set to next column everytime I finished recording and save the excel and run it again.
thanks again,
Ery
09-19-2011 10:03 AM
Hi, Ery.
I'm not sure I understand what's not working, but you can rewire the output from the attached VI and it will give you the next column number. I've modified it to return the next column as well as row.
Jim
09-19-2011 10:45 AM
Hi Jim,
I try to wire the output of get next row & column but it couldn't be connected, I attached the picture and my vi
thanks,
Ery
09-19-2011 10:56 AM
Oops. I don't know when it happened, but there was a class conflict. I had the terminal wired incorrectly, but that doesn't tell me how the type changed. Anyway, here's a corrected VI.
You may also need to modify the wiring a bit to get the
or, this
depending on what you're trying to do. Regardless, you can't set the column tunnel to Use Defaults if Empty because you'll get a zero every time after the first loop. Use a Shift Register to carry it back around.
09-19-2011 11:32 AM
Yeap, thanks, it's working now, but the system seems a bit wierd, I attached the picture show how exactly what I need when run and stop then run again this vi which show the result on excel
Thanks,
Ery
09-19-2011 11:55 AM - edited 09-19-2011 11:55 AM
You need to understand how the Shift Register works with the Case Structure. The True case is where you put the initial Row,Column pair. You want the row to always start at 1 and the column to start with whichever is next. The false case is where you'll increment the cell position. You want the row to increment and the column to stay the same. As Nike says: "Just do it."
09-20-2011 03:43 AM
Thanks Jim, Just as you said, I put it that way, but I keep getting the next row(1048577) and Next Column(16385) which is nothing show on the excel
Ery